Forum Discussion

jmiridium's avatar
jmiridium
Helper IV
9 years ago
Solved

Refresh Error

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

  • Anonymous's avatar
    Anonymous
    9 years ago

    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,

7 Replies

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

    • jmiridium's avatar
      jmiridium
      Helper IV

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      jmiridium
      Helper IV

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

      • Anonymous's avatar
        Anonymous
        Not applicable

        jmiridium,

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

        Regards,