Troubleshoot Power BI data discrepancies for Jira Align Enterprise Insights
Summary
This article addresses a data discrepancy where Power BI reports sourced from Enterprise Insights (EI) show no teams associated with a specific Program Increment (PI), despite those teams being visible in the Jira Align interface. This issue typically occurs due to data model join logic or filter configurations within Power BI rather than missing data in the underlying database.
Cause
The discrepancy is often caused by the specific join logic used in custom Power BI reports. In the reported cases, the relationship between teams and Program Increments is established through a chain of joins (Team → Program → MAP Program Increment to Program → Program Increment). If any link in this chain contains filters or logic that excludes specific IDs, the resulting report will incorrectly show zero associations.
Solution
To resolve or troubleshoot data discrepancies between the Jira Align UI and Enterprise Insights reports, follow these steps to isolate the source of the missing data.
Step 1: Verify data existence in the Enterprise Insights database
Run a direct SQL query against your Enterprise Insights database (using a tool like Azure Data Studio or VS Code) to confirm the data exists independently of Power BI.
Execute the following query to identify teams associated with the affected Program (replace <PROGRAM_ID> with your specific Program ID):
SELECT *
FROM [current_dw].[Team]
WHERE [FK Program ID] = <PROGRAM_ID>If this yields results, verify the association with the specific Program Increment using a join:
SELECT Team.[Team ID], Team.[Team Name], PI.[Program Increment ID], PI.[PI NAME]
FROM [current_dw].[Team] AS Team
LEFT JOIN [current_dw].[Program Increment] AS PI ON Team.[FK Portfolio ID] = PI.[FK Portfolio ID]
WHERE Team.[FK Program ID] = <PROGRAM_ID>
AND PI.[Program Increment ID] = <PI_ID>Step 2: Validate via Jira Align API
Confirm the backend data via the API to isolate if the issue is specific to the EI sync from our JA databases.
Navigate to
https://<your-instance>.jiraalign.com/rest/align/api/docs/index.htmlAuthorize using your Jira Align token
Locate the Releases (Program Increments) endpoint.
Perform a
GETcall for/align/api/2/Releases/<PI_ID>.Review the JSON response to confirm the expected team and program mappings are present.
Step 3: Review Power BI Data Model and Filters
If Steps 1 and 2 confirm the data exists in the database and API, investigate the Power BI report logic:
Review further the Manage Relationships (Data Model) view to ensure the joins between current_dw.Team, current_dw.Program, and current_dw.Program Increment are correct (e.g., Many-to-One, One-to-One).
Identify if any report-level or page-level filters are excluding specific values.
Simplify the join logic in a new Power BI tab using Transform Data to see if a basic connection between Team and Program Increment tables displays the data.
If the issue still persists, reach out to Atlassian support team to further investigate.
Was this helpful?