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
Token Generation:
Within Time & Cost Tracker API, generate a token for authentication.
Authorization:
Visit the Time & Cost Tracker API requests website.
Utilize the generated token to authenticate your request.
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:
Web Data Source:
In Power BI Desktop, create a new report and select "Web" as the data source.
Swagger Data:
Populate the fields with values obtained from Swagger, as outlined in the documentation.
Table Modification:
Ensure the retrieved data table is appropriately modified to meet your specific reporting needs.
Data Visualization:
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.