How to Troubleshoot the missing work log data in Power BI from the Tempo Timesheets

Owned by Kinnera, created
Last updated: Jun 10, 2024 by Amith Mathur
2 min read

This article provides a step-by-step guide on identifying and resolving issues related to missing work log data in Power BI when using the Tempo Timesheets app.

Troubleshooting steps

  1. Verify API Responses:

    • Use this REST API https://<Base_URL>/rest/api/latest/issue/TEST-2/worklog to fetch work log data directly from Jira. Replace <Base_URL> with your Jira instance URL. Check if the worklog data, like hours logged, appears as expected under the timespent field.

  2. Check Worklog visibility in Jira:

    • Go to the specified issue in Jira (e.g., TEST-2). Under the Activity section, check the Worklogs tab to see if the user's worklog entry is visible.

  3. Run a JQL Query in Issue Navigator:

    • Execute a JQL query to confirm the work log entries are recorded in Jira: key = TEST-2 AND worklogAuthor = <user> AND worklogDate = 2020-01-01. Adjust the query parameters to fit the issue key, actual user, and date concerned. If the query returns no results, it indicates that the work log isn't recorded or you do not have the necessary permissions to view it.

  4. Permission Verification:

    • Ensure you have the required permissions to view all worklogs. Consult with your Jira administrator to verify or modify your permissions if necessary.

  5. Contact Tempo Support:

    • If the above steps confirm that worklogs are being entered but not synchronised properly, contact Tempo Timesheets support for assistance. Provide them with details of the missing worklogs and any relevant screenshots or API responses to help diagnose the issue.

  6. Reset and Refresh Data Integration:

    • Once the Tempo support resynchronises the data into Jira, reset the Tempo Integration within the Power BI Jira Connector app and reload the data to see if this resolves the synchronization issues.

Conclusion

Following these steps should assist in identifying and resolving issues related to missing work log data in Power BI when integrating with Tempo Timesheets. If further assistance is required, please open a support ticket with us from our portal, appf.re/support, with comprehensive details on the missing data.