abenlazreg
New Member
- Joined
- Jun 6, 2019
- Messages
- 1
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?
Join between tables
I thank you in advance.
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?
Join between tables
I thank you in advance.