Skip to main content
Microsoft Idea

Power BI

Needs Votes

ADD “Join Kind” Option inside Edit Relationship Window in Power BI Model

Vote (34) Share
Osama Abu Asal's profile image

Osama Abu Asal on 22 May 2021 20:05:33

Kindly Vote on this idea if you like it.
I have a great idea that could improve Power BI product greatly, which is ADD "Join Kind" Option in Power BI Model Edit Relationship Window (When we create a new join between two tables), so this is better than detect a default Behavior join in Power BI Model which is Left.

I know that we can do it by merge queries and choose the join kind (Inner, Left, Right…Etc.) in the Query editor, but If we can directly set the join type in Power BI Model, the function will be better.

This Idea will help many users and will support All types of businesses around the world and will Facilitate and speed up work and effort, because not all companies or organizations have a Unified database design, And it’s so hard to convert all joins to a specific type of join using merge queries and convert all tables to FLAT table, Note that many companies have a huge number of tables in their databases And they need all the relationships between tables inner not left (Or Any type of Join).

The Clients Around the world Use Left Join and Inner Join the most, so Power BI Model Should make it easy to choose the join type Regardless the DB Design, Business, Schema Type Or Data.

I made this Idea because it exists On Many Business Intelligence tools so it should also available in Power BI.

Comments (8)
Osama Abu Asal's profile image Profile Picture

Raed Mansour on 01 Jun 2021 05:11:16

RE: ADD “Join Kind” Option inside Edit Relationship Window in Power BI Model

this is a good idea and will help and add value

Osama Abu Asal's profile image Profile Picture

Mohammed Ramahi on 31 May 2021 13:16:09

RE: ADD “Join Kind” Option inside Edit Relationship Window in Power BI Model

wow , amazing

Osama Abu Asal's profile image Profile Picture

Mohammad Abedrabbu on 23 May 2021 06:44:31

RE: ADD “Join Kind” Option inside Edit Relationship Window in Power BI Model

That sounds like a great idea 💡, it will help us in terms of execution time and memory performance.
Thank you Osama ❤️

Osama Abu Asal's profile image Profile Picture

Hussam Daabes on 23 May 2021 06:16:47

RE: ADD “Join Kind” Option inside Edit Relationship Window in Power BI Model

That would be a perfect idea , since it will make work much easier.👍

Osama Abu Asal's profile image Profile Picture

Ahmad Masoud on 23 May 2021 05:27:33

RE: ADD “Join Kind” Option inside Edit Relationship Window in Power BI Model

we really need it. It will improve the quality of work and make it easier and more efficient.

Osama Abu Asal's profile image Profile Picture

Raghad Sulieman on 22 May 2021 21:14:30

RE: ADD “Join Kind” Option inside Edit Relationship Window in Power BI Model

Great idea 💡 , and very need for this feature, thank you Osama

Osama Abu Asal's profile image Profile Picture

Omar Sameer Zaidan on 22 May 2021 20:49:40

RE: ADD “Join Kind” Option inside Edit Relationship Window in Power BI Model

Great idea it will help alot during usage of power bi

Osama Abu Asal's profile image Profile Picture

Abdullah Abdelrazzaq on 22 May 2021 20:12:27

RE: ADD “Join Kind” Option inside Edit Relationship Window in Power BI Model

That's a great idea, it will help and make the work more easier, thanks alot Osama for this great idea 💡