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.

If you need help or want to ask questions, please contact SaaSJet Support or email us at support@saasjet.atlassian.net .

Haven't used this app yet? Try it now! >>>