Forum Discussion
Solved
Left Join using relationship in Power BI direct query mode
Hi All, We have a requirement to show information from one table and matching information from other 2 tables. The table are suppose A , B and C. A is joined with B with 1 **N and A is Joined wit...
Remember that dimensions need to control facts. Dimensions are things you group/filter by. Facts are things you measure.
You mention Direct Query mode but your data model screenshot shows Import Mode. Please clarify.
Hi lbendlin
Thanking you for your response. The actual scenario is for direct query. But to create a sample and share it in the forum , i have created it in import mode.
That's not gonna work, as the query behavior will be different. This can only be tested by setting up a Direct Query source like a SQL Server database or a secondary semantic model.