Forum Discussion
Data Model and Connections between Tables
Hello everyone!
I have a Problem regarding my Data Model. I am constructing a Dashboard using three tables from three different databases. I have connected the databases and most things work fine. The problem is that I need more than one connection between the tables, becuase PowerBI doesn`t seem to recognize all necessary similarities between the tables. Of course PowerBI only allows one active connection between tables, as far as I am concerned. Now I am searching for a workaround and I hoped somebody on this forum has some ideas on how to maybe solve this issue.
Thanks in advance!
2 Replies
Will Duplicating or Referencing the Data in Power Query solve your purpose?
Hi, Anonymous
If you want to have more than one active relationship between tables, you can try using the USERELATIONSHIP() function, which can be turned into an active relationship when the function operates.
Please refer to the following link, hope it can help you.
https://docs.microsoft.com/power-bi/guidance/relationships-active-inactive
https://docs.microsoft.com/dax/userelationship-function-dax
https://community.powerbi.com/t5/Desktop/Using-Inactive-Relationship/m-p/2135672
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
