Power BI
Needs VotesADD “Join Kind” Option inside Edit Relationship Window in Power BI Model
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)
RE: ADD “Join Kind” Option inside Edit Relationship Window in Power BI Model
this is a good idea and will help and add value
RE: ADD “Join Kind” Option inside Edit Relationship Window in Power BI Model
wow , amazing
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 ❤️
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.👍
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.
RE: ADD “Join Kind” Option inside Edit Relationship Window in Power BI Model
Great idea 💡 , and very need for this feature, thank you Osama
RE: ADD “Join Kind” Option inside Edit Relationship Window in Power BI Model
Great idea it will help alot during usage of power bi
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 💡