Not able to create to a relationship

[ROG]

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.

[v-junyant-msft · Accepted solution]

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.

[VahidDM]

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]

Thanks @VahidDM 

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

Would you be able to advice?