Forum Discussion

ROG's avatar
ROG
Icon for Responsive Resident rankResponsive Resident
2 years ago
Solved

Not able to create to a relationship

Hey guys,

 

I need to connect two tables, but I'm getting the error below.

 

 

 

1 table comes from databricks

2nd table was created in PBI with a union statement (see below)

 
Table - TopCarrier =
UNION(
    VALUES(feRR_ads_1143_weekly_porting_5c[Carrier]),
ROW("Carrier","Others")
)

 

 

How can I connect them?

 

Many thanks.

 

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi ROG ,

    The error message “A circular dependency was detected” usually occurs when there is a loop in the relationship between two tables. This means that one table depends on another table, which in turn depends on the first table. This creates a cycle that Power BI cannot resolve.
    Please check the relationships between the tables and make sure that there are no loops and check the calculated columns or calculated tables and make sure that they do not reference each other in a circular manner.
    If you find a circular dependency, you will need to restructure your relationships. This might involve removing or changing the direction of some relationships. Ensure that your relationships flow in one direction to prevent loops.
    If you are unable to solve your problem, could you please provide your sample data and data model?

    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    2 years ago

    Hey ROG 

    If you create the second Table in Power Query then this will be fixed.

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos!! 

    LinkedIn | Twitter | Blog | YouTube 

    • ROG's avatar
      ROG
      Icon for Responsive Resident rankResponsive Resident
      2 years ago

      Thanks VahidDM 

       

      I have tried using the same logic above in PQ, but no success.

      Would you be able to advice?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi ROG ,

    The error message “A circular dependency was detected” usually occurs when there is a loop in the relationship between two tables. This means that one table depends on another table, which in turn depends on the first table. This creates a cycle that Power BI cannot resolve.
    Please check the relationships between the tables and make sure that there are no loops and check the calculated columns or calculated tables and make sure that they do not reference each other in a circular manner.
    If you find a circular dependency, you will need to restructure your relationships. This might involve removing or changing the direction of some relationships. Ensure that your relationships flow in one direction to prevent loops.
    If you are unable to solve your problem, could you please provide your sample data and data model?

    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.