Metrics report refresh got failed

[MadhuKumar]

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(screenshot attached).

Can you please help me on how to fix this issue.

Thanks in advance.

Madhu

[MadhuKumar]

Thanks for the help, this solution has been worked out

[pradeep_kare12 · Accepted solution]

@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.