Refresh Error

[jmiridium]

I need help figuring out this error message:

I have to say troubleshooting PowerBI errors is extremely difficult. There is no clear chain of evvents that causes the error and you can't copy and paste the error. The first error that caused this issue should be listed first.

How do I fix this error? There is no relation that it mentions

[v-yuezhe-msft]

@jmiridium,

As the error indicates, the ‘Blades’ column can’t contain duplicate values when you create relationship using this column of  ‘ClusterInfoSNOC’ table(one side) and other column of other table(many side). To make the refresh work properly, make sure that ‘Blades’ column contains distinct values when you use the column to create relationship, otherwise, you would need to delete the relationship.

Regards,
Lydia

[jmiridium]

I disabled all relations on the SNOC table and still have the issue

[v-yuezhe-msft]

@jmiridium,

What is your data source? Would you please share me the sample tables so that I can test?

Regards,

[jmiridium]

I have posted this elsewhere:

http://community.powerbi.com/t5/Integrations-with-Files-and/Refresh-Errors/m-p/192646#M10818

However, it is different errors at different times. It's not the data source, it's fine. This just needs support to work on this bug.

[v-yuezhe-msft · Accepted solution]

@jmiridium,

Please follow Qiuyun Yu's suggestion in your another thread to edit the data source and then check if you get any issues. 

Regards,

[jmiridium]

I should also state that this same query is in other pages and runs without issue. Please help

[jmiridium]

I found the issue and deleted the relationship. However it now shows infor from all clusters. Really need this to work reliably