Forum Discussion
Scorecard Refresh Failure - Duplicate 'Id' in 'Values' table
Hi TR_KY_PBI ,
Could you please download the pbix from the Power BI Service. You can find the dataset in the workspace.
More details: Create scorecards and manual goals in Power BI
You can open the pbix file on the Power BI Desktop and refresh it to find the error. And you can download and operate it without affecting the user's use.
Similar post: Get "not allowed for columns on the one side of a many-to-one relationship" errors
- Manage Relationships
- enable the relationship
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Unfortunately, I am unable to download the pbix file from any scorecard dataset.
I tested this with the dataset that was producing the error and with a few other test Scorecard datasets as well, and received the same result. It appears that Microsoft does not allow downloads of the pbix for Scorecard datasets?
The only way I am able to connect to this dataset from a pbix is through a live connection
While this shows the tables/relationships, it does not allow me to refresh each table independently to help me identify the error.
Is there another way to find the source data for the scorecard? Is it sitting in Azure somewhere that I can locate/analyze it to find and get rid of the duplicate?