Forum Discussion

Hitu's avatar
Hitu
Frequent Visitor
1 year ago
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 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 

 

Need Help

8 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

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

    • Hitu's avatar
      Hitu
      Frequent Visitor
      1 year ago

      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's avatar
        lbendlin
        Super User
        1 year ago

        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.

  • v-venuppu's avatar
    v-venuppu
    Community Support
    1 year ago

    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.

  • v-venuppu's avatar
    v-venuppu
    Community Support
    1 year ago

    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's avatar
    v-venuppu
    Community Support
    1 year ago

    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.