Forum Discussion

jmiridium's avatar
jmiridium
Helper IV
9 years ago

Yet Another Refresh Error

Getting a refresh error. I haven't changed anything on the pbix file. Yet the relations are now having issues. I REALLY need refresh to be stable:  
Need Help
jmiridium's avatar
jmiridium
Helper IV
9 years ago

I took out the relations and refresh worked. How come this relation failed now but worked before?

Anonymous's avatar
Anonymous
Not applicable
9 years ago

jmiridium,

There is a possibility that the "Computer Name" column doesn't contain duplicate values before, but after you make some changes in the data source(not PBIX file), the "Computer Name" column contains duplicate values breaking the relationship between tables, leading to refresh problem in Power BI Service.

Regards,
Lydia

  • jmiridium's avatar
    jmiridium
    Helper IV
    9 years ago

    I just removed the relationship. Didn't effect the report. However, going over the data didn't show a duplicate entry

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      jmiridium,

      Please make sure that you Remove duplicates in Query Editor of Power BI Desktop as shown in the following screenshot. Then check if you get the error in Power BI Desktop and Power BI Service.


      Regards,