Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I know previously it was not possible using PBI to join on multiple columns (or when using direct query).
Has that changed at all?
We have users who want to use direct query and have many tables that need to link on more than 1 column.
I'd like to be able to just let them drag and drop the tables without having to create a custom SQL view instead.
Solved! Go to Solution.
Hi @Anonymous,
Has your issue be solved?
Regards,
Frank
Hi @OneWithQuestion,
Does that make sense? If so, kindly mark the answer as solution to close the case.
Regards,
Frank
Hi @OneWithQuestion,
Based on my test, we can create relationship between tables by multi columns, However we can only make one active. You can use the USERELATIONSHIP function to work with the inactive relationship.
Regards,
Frank
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |