Power Bi API integration

By integrating Time & Cost Tracker API with Power BI you will get real-time cost data visibility for impactful business decisions.

What is needed:

• Access to Time & Cost Tracker API

• Power BI Desktop

• Basic understanding of API integration and Power BI

Authentication

1. Token Generation:

   • Within Time & Cost Tracker API, generate a token for authentication.

2. Authorization:

   • Visit theTime & Cost Tracker API requests website.

   • Utilize the generated token to authenticate your request.

     

3. Data Selection:

   • Choose the desired data parameters for retrieval:

     • Report ID (for overall report data)

       

     • Issue Key(s) (for labor expense data associated with specific issues)

       

Power BI Integration:

1. Web Data Source:

   • In Power BI Desktop, create a new report and select "Web" as the data source.

2. Swagger Data:

   • Populate the fields with values obtained from Swagger, as outlined in the documentation.

     

3. Table Modification:

   • Ensure the retrieved data table is appropriately modified to meet your specific reporting needs.

     

Data Visualization:

1. Graph Creation:

   • Utilize Power BI's extensive visualization capabilities to create informative and impactful graphs, effectively communicating key cost insights.

     

Data Availability:

Report Data by Report ID:

• Total Worklog Minutes

• Cost Labors

• Cost Expenses

• Total Cost

• Currency

• Timestamp

Cost Tracker Labor Expense by Issue(s) Keys:

• Timestamp

• Issue Key

• StartDate

• End Date

• Currency

• Worklog Minutes

• Cost Labors

Benefits:

• Real-Time Updates: Benefit from continuous data updates by establishing a refresh schedule within Power BI.

• Data Security: Exercise stringent measures to safeguard sensitive cost data, adhering to organizational security protocols.