How to troubleshoot integration issues with Power BI Connector and Tempo Timesheets
Overview
If you experience difficulties with the Power BI Connector and Tempo Timesheets integration, the issue is typically caused by the connection expiring every month or every six weeks. As a result, you need to repeatedly re-establish the connection, which can be inconvenient.
Recommended solution: Manual Re-integration
This issue often occurs when the Tempo API fails up to five consecutive times. In such cases, manually re-integrating the connector is recommended to restore functionality.
Best practices to improve integration stability
1. Avoid running multiple simultaneous connectors
Ensure that you do not run multiple connectors simultaneously.
Running several connectors in parallel can cause conflicts and increase system strain.
Limiting the number of active connectors helps prevent unexpected disconnections and performance issues.
2. Optimize JQL queries
Restrict the connector’s JQL (Jira Query Language) to a single project.
This optimization can significantly reduce load times and enhance integration efficiency.
Narrowing the JQL scope minimizes the data being processed, leading to faster load times and more reliable integrations.
By following these best practices, you can achieve a more stable and manageable integration experience between Power BI Connector and Tempo Timesheets.