How Joins and Relationship works and their difference in Power BI?

[Anonymous]

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?

[dax · Accepted 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.