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:

  2. Authorization:

    • Visit the Time & Cost Tracker API requests website.

    • Utilize the generated token to authenticate your request.

      Знімок екрана 2024-02-06 о 08.58.44.png
  3. Data Selection:

    • Choose the desired data parameters for retrieval:

      • Report ID (for overall report data)

        Знімок екрана 2024-02-06 о 09.01.26.png
      • 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.