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.
I am migrating dashboards from Tableau to Power BI, literally confused whether to go for table relationship or Joins. It was pretty easy to build a relationship in Tableau. I am totally confused when it comes to how these two options are different. Can someone help me with this?
Solved! Go to Solution.
Hi haritima_tiwari,
In powerbi, join and relationship are difference.
When tables contains available relationships, you can direct table fields to build visuals and graphs, records which used in visuals will auto analysis and summarize on current category through existed relationship. If not exists availed relationship, you can't direct use amount field from different tables, they not summarize so you need to write measure with particular filter conditions manually to display correspond summary result.
And join will create a new table for you.
You could refer to demystify-joins-in-power-bi.html and Create and manage relationships in Power BI Desktop for deatils.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi haritima_tiwari,
In powerbi, join and relationship are difference.
When tables contains available relationships, you can direct table fields to build visuals and graphs, records which used in visuals will auto analysis and summarize on current category through existed relationship. If not exists availed relationship, you can't direct use amount field from different tables, they not summarize so you need to write measure with particular filter conditions manually to display correspond summary result.
And join will create a new table for you.
You could refer to demystify-joins-in-power-bi.html and Create and manage relationships in Power BI Desktop for deatils.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |