Forum Discussion
Solved
Metrics report refresh got failed
Hi All, I have created a metrics report by using datasets from 2 production workspaces. Since last week it was refreshed successfully, but now the refresh got failed and throughing an error(scree...
MadhuKumar To reslove this you will need to identify and eliminate the duplicate value in the userid column. For this you can use Power query, in power query select the users table and use the remove duplicate function to identify duplicate values in the userid column.
After you get the duplicate values in your data source, refresh your powerbi data model to ensure it reflects the corrected data.
If the userid column is intended to be the primary key for the users table, verify that its now meets your requirement.
Thanks for the help, this solution has been worked out