Forum Discussion

MadhuKumar's avatar
MadhuKumar
Helper II
2 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.