Forum Discussion
composite model inner join
i want to show blank row with 2 cases count as shown below in composite mode. I am able to see this blank row in case of import and direct query however this blank row is not appearing in case of com...
The only scenario that comes to my mind is when using composite models , Power BI aims to optimize performance so it pushes the join operations down to the data source The data source, in turn, typically performs an inner join unless specified otherwise.
In your case, you have a table in DQ mode and another in import mode, Power BI tends to perform an inner join between these tables, especially when there is a relationship defined between them. This inner join excludes rows from the Case table where the groupid is blank that's why you don't see them.
Hi AmiraBedh ,
how to perform left outer join in this case?
I share the same opinion as tharunkumarRTK your visual is sending only one SQL query for each unique groupid.
