Forum Discussion

bhanu431's avatar
bhanu431
Frequent Visitor
9 years ago

circular dependency detected

I have a report in which i have created a dependency for mainting the order. Let's Assume I have Input data of table BSE Index with column Name Capital Markets in order                             ...
MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
9 years ago

You seem to have a 1 to 1 relationship plus no other relationships. Is it possible that one of your tables now contains duplicate values?  Try deleting the relationship, then refresh, rejoin the tables and see what happens. 

bhanu431's avatar
bhanu431
Frequent Visitor
9 years ago

Thanks Matt

 

I have deleted the relationships and configured again, still the issue remains. Any other suggestion please

  • MattAllington's avatar
    MattAllington
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Sorry to be pedantic. Do you delete, refresh all queries then recreate the relationships?  Or did you delete, recreate and then refresh. You should do the former. 

    • bhanu431's avatar
      bhanu431
      Frequent Visitor
      9 years ago

      I deleted relationship then refreshed and then recreated as you said previously. Still nothing going in my way.

      • bhanu431's avatar
        bhanu431
        Frequent Visitor
        9 years ago

        The refresh is happenig properly on PowerBI Desktop, the refresh is failing on powerBI app