Forum Discussion
AdministratorRelate tables
Hi jalbornoz ,
First, only one relationship can be set to be active between two tables. You can review the following official documentation to get more details.
Create and manage relationships in Power BI Desktop
And the following links are the threads which has the similar problem as yours, you can refer them to solve it.
Can't create a direct active relationship
Make sure you are not creating a relationship loop or two paths. Like A- B and B- C also Have A-C this means two path. Also if both A-B and B-C are M to M bi-direction then it will create a problem.
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
You can't create a direct active relationship between A and B because that would introduce ambiguity
If the above one can't help you get the expected result, could you please provide the involved tables, connected fields between the tables and relationship info etc. ? Also please provide your final expected result, then we can check if there is another workround to get it instead of creating relationship. Thank you.
And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Hi jalbornoz ,
First, only one relationship can be set to be active between two tables. You can review the following official documentation to get more details.
Create and manage relationships in Power BI Desktop
And the following links are the threads which has the similar problem as yours, you can refer them to solve it.
Can't create a direct active relationship
Make sure you are not creating a relationship loop or two paths. Like A- B and B- C also Have A-C this means two path. Also if both A-B and B-C are M to M bi-direction then it will create a problem.
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
You can't create a direct active relationship between A and B because that would introduce ambiguity
If the above one can't help you get the expected result, could you please provide the involved tables, connected fields between the tables and relationship info etc. ? Also please provide your final expected result, then we can check if there is another workround to get it instead of creating relationship. Thank you.
And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards