Forum Discussion
Multiple connections with one table
Dear Community,
I have an issue with connecting related tables which I struggle to solve. I am connecting tables manually as PowerBI does not seem to be able to auto-detect all connections.
I am working with a database that contains a main table ("header") filled only with IDs ("1", "2") and referenced tables that relate to specific columns of the main table (in that case this table contains the information that 1=yes; 2=no). There is no problem to establish one single connection between a particular reference table and the main table. However, there are some reference tables that have connection to multiple columns in the main table since many question in my main table are binary yes/no questions.
As soon as I try to connect the reference table to a second column in the main table, PowerBI cannot establish that connection and reports an error that the connection is not unique.
Is there any solution to this? Can I reference a table multiple times?
Thank you very much in advance!
Best wishes,
Simon
4 Replies
Generally you can connect two tables together multiple ways but the secondary connections are not active. You use USERELATIONSHIP to get around this.
Anonymous，
I have an issue with connecting related tables which I struggle to solve. I am connecting tables manually as PowerBI does not seem to be able to auto-detect all connections.
I am working with a database that contains a main table ("header") filled only with IDs ("1", "2") and referenced tables that relate to specific columns of the main table (in that case this table contains the information that 1=yes; 2=no). There is no problem to establish one single connection between a particular reference table and the main table. However, there are some reference tables that have connection to multiple columns in the main table since many question in my main table are binary yes/no questions.
As soon as I try to connect the reference table to a second column in the main table, PowerBI cannot establish that connection and reports an error that the connection is not unique.
To many relationships may lead to circular reference issue. I would suggest you to rearrange the relationships between tables.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous ,
Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.
Regards,
Jimmy Tao
Dear all,
I have resolved my issue by renaming my data with the IF Dax formula, i.e. replacing codes (1,2,3 etc.) with the actual text. I can now show the data without having to connect to some of the referenced tables. However, the actual problem of having to connect some of the tables multiple times has not been solved.
Best wishes,
Simon
