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

5 Replies

  • 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

  • DouglasJMartin's avatar
    DouglasJMartin
    Regular Visitor
    8 years ago

    I have a similar Relationship issue upon refreshing, i use a link table with a DAX function that works so as to insure no duplicates. The refresh works fine on desktop but not on Service. I am sourcing the data from a SharePoint folder. Any help greatly appreciated.