Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Join between tables

Hello,
Regarding the binding of tables in Power BI, I would like to know how to make this connection, in the habitiude in SQL, we do the join or the connection between the tables with a primary key, but in Power BI I noted that There are linked tables with other fields.
For example in this screenshot, I would like to join these two tables Stock and orders, Can we join them with the fields date or Year, or month or company since they exist in the two tables? And what is the difference between joining with a primary key and joining with a normal field?

I thank you in advance.

liaison table.PNG

5 REPLIES 5
v-shex-msft
Community Support
Community Support

Hi @Anonymous ,

In fact, you not need to join fields to another table.
After you finished to create relationships, you can direct to use table fields to create chart/visuals.(power bi will analyze summarize these fields based on current relationship and group fields)

Create and manage relationships in Power BI Desktop

Work with aggregates (sum, average, and so on) in the Power BI service

BTW, after you build relationship between tables, you can add a calculated column with related function to simply invoke related field from related table.

RELATED

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

Do you mean that the join and the relationship is not the same or I misunderstood?

@Anonymous 


Hi,


JOIN and RELATIONSHIP work on similar fundamentals, i.e. there should be one common field between the two tables. However, the major difference between them is that by using JOIN you are compiling all the data into one table and then creating your reports/data model; however, using RELATIONSHIPS you can achieve the same results by linking the two tables.

In your case, you can first create a relationship between stock and order table and then proceed with creating visuals or tables.

And I do not think that there is any difference between joining with a primary key and joining with a normal field. As long as you can create a unique combination for the query to map the required field, the result should not be any different.

 

Thanks,

Vivek

Anonymous
Not applicable

If we make a link between the tables with a normal field not unique then we will have values that are repeated !!
In your opinion how to create a relationship? I did not understand how to link 2 tables, I know that with the primary key it's all

Between Stock and Order table, I am hoping that there should be column for ItemID or ProductID.

Even for Join, you would need something common between the two tables

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.