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.
Hi Community,
Does any know the DAX expression to use when I need to join 2 tables on 5 columns. Note, I am using a live connection to SSAS. On a super tight deadline. Please and Thank you to anyone that can help!! 😁
Michelle
Solved! Go to Solution.
Hi, @Anonymous
In DAX language, we use NATURALLEFTOUTERJOIN() and NATURALINNERJOIN() to join tables, but you can’t set the join columns for the two tables. The join condition is based on columns having the same name in the tables involved.
In my opinion, I prefer to do the data modeling operations in the SSAS database, because when we use a live connection to connect to SSAS in Power BI. The data model is created and stored in the data source instead of Power BI. Power BI can only connect to it and query the data in real-time.
What’s more, the amount of data in SSAS is particularly large. Using DAX to re-associate tables in power bi will have a great impact on the efficiency of reports and data, so I don't recommend you to do so.
Data modeling in SSAS Tabular model
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
In DAX language, we use NATURALLEFTOUTERJOIN() and NATURALINNERJOIN() to join tables, but you can’t set the join columns for the two tables. The join condition is based on columns having the same name in the tables involved.
In my opinion, I prefer to do the data modeling operations in the SSAS database, because when we use a live connection to connect to SSAS in Power BI. The data model is created and stored in the data source instead of Power BI. Power BI can only connect to it and query the data in real-time.
What’s more, the amount of data in SSAS is particularly large. Using DAX to re-associate tables in power bi will have a great impact on the efficiency of reports and data, so I don't recommend you to do so.
Data modeling in SSAS Tabular model
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Robert, that is what I'm gathering here with all my research. Appreciate the response.
Michelle 😁
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 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |