Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Problem while building relationship

  • 1.  Problem while building relationship

    Posted 30 days ago
      |   view attached
    hi guys i want small help from you,tried t create relationship between tables in this excel file,partially succeeded.created 1-* many relationship between 2 tables,but failed to relate other table,i am getting error as "circular dependency detected".i have created 2 dimension tables and 1 metric table using 'group by' and 'summarizecolums'',but i failed.so please help me out hope u guys suggest me the best practices to build relationship between tables.i am attaching the excel file,please check it out.thanks in advance.

    Kiran K
    Power Bi Developer
    +91 40 62169922


    sample_sales.xlsx   76K 1 version

  • 2.  RE: Problem while building relationship

    Top Contributor
    Posted 30 days ago
    Which relationship failed?
    What columns were you creating the relationship with?
    Can you give us a screenshot of the relationship panel?

    I just imported your excel tables to Power BI Desktop and didn't have any trouble creating relationships.
    There was one null record in the Country table that needed to be removed, but other than that - no issues.

    Audrey Abbey
    SR. BI Developer/Analyst
    Portland OR


  • 3.  RE: Problem while building relationship

    Posted 21 days ago
    Hi Kiran.  I didn't do a lot of analysis and it's impossible to tell without seeing your pbix / data model, but you seem to have some duplicates in your 3rd tab.  I'd maybe check this out.

    Paul Jennett