Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Our vendor system that we are using as a data source has several tables that use a combination primary key and for relationships to other tables you have to join on 3 or 4 columns (I hate it, I do not know WHY they do it...but it is the way it is).
Is there anyway to support that in Power BI Desktop using Direct Query?
In a Tabular data model I can make a calculated column to achieve this, however... it does not seem possible to do multiple column relationships in the modeling option for Direct Query Mode?
Solved! Go to Solution.
Hi @OneWithQuestion,
In Direct Query, you are still able to create a calculated column to combine multiple columns to generate the primary Key.
Col4 = Test5[Col1]&" "&Test5[Col2]
ColC = Test6[ColA]&" "&Test6[ColB]
Best regards,
Yuliana Gu
After seven months and no activity on the performance issue that this approach of merge can cause.
UPDATE 07/07/2023 in behalf of my previous post
I have tested this on tables with million of rows using Direct Query, very very bad idea...
This is true and can be done, although is not very performant as the query is no longer hitting the actual column predicates for the join, right?
Hi @OneWithQuestion,
In Direct Query, you are still able to create a calculated column to combine multiple columns to generate the primary Key.
Col4 = Test5[Col1]&" "&Test5[Col2]
ColC = Test6[ColA]&" "&Test6[ColB]
Best regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |