Data refresh error when connecting GitHub Copilot Metrics PowerBI report to GitHub Copilot Metrics API

[jack-ton]

Select Topic Area

Question

Body

I am trying to use the following PowerBI report owned by GitHub to visualize GitHub Copilot and provide insights to upper management in terms of user engagement and ROI for using Copilot:
https://appsource.microsoft.com/en-us/product/power-bi/github.github-copilot-metrics

However, I am running into the following error when trying to connect to the data source:

Data source error: Column 'usage_records.date' in Table 'CopilotEnterpriseUsageNewSchema' contains a duplicate value '1/13/2025' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
Cluster URI: WABI-CANADA-CENTRAL-redirect.analysis.windows.net
Activity ID: 0d911308-8ccb-4290-9a59-cad8b4ed0a72
Request ID: 082bf557-1bfb-eb11-4b20-a6d9e9b741b7
Time: 2025-01-16 20:12:26Z

I can't edit the data model for this report. Please let me know who I can talk to resolve this issue.

[jack-ton]

Update to the latest report version now. The issue is resolved.