Yet Another Refresh Error

[jmiridium]

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:

[DouglasJMartin]

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.

[jmiridium]

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

[v-yuezhe-msft]

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

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

[v-yuezhe-msft]

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