Left Join using relationship in Power BI direct query mode

[Hitu]

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 with C with 1 **N. We have to achive this using relationship , not using merge query in Power Query. 
Please find the screen shoot of mock up data and expected output along with the sample pbix.

Requesting your valuble suggestion 

one-to-many relationship 

[v-venuppu]

Hi @Hitu ,

I hope the information provided is helpful.I wanted to check whether you were able to resolve the issue with the provided solutions.Please let us know if you need any further assistance.

Thank you.

[v-venuppu]

Hi @Hitu ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

[v-venuppu]

Hi @Hitu ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @lbendlin for the prompt response.

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.

[lbendlin]

You mention Direct Query mode but your data model screenshot shows Import Mode.  Please clarify.

[Hitu]

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.

[lbendlin]

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.

[Hitu]

Yes true. But to enable the forum user to understand the requiremnet i have make this pbix with sample data in import mode.

[lbendlin · Accepted solution]

Remember that dimensions need to control facts.  Dimensions are things you group/filter by. Facts are things you measure.