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.
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.
