Forum Discussion

mehmetpowerbi's avatar
mehmetpowerbi
Regular Visitor
8 years ago

Left join in Power BI QNA

Hi all,   I  am experimenting with Power BI  Q&A.  However I couldn't figure out how to ask a proper question for illustrating Left JOIN scenario.    Let me give you my sample scenario: I have [c...
Need Help
dilumd's avatar
dilumd
Icon for Impactful Individual rankImpactful Individual
8 years ago

Is it possible for you to try merge facility in power query?

 

 

 

  • mehmetpowerbi's avatar
    mehmetpowerbi
    Regular Visitor
    8 years ago

    Hi dilumd,

     

    I need to use Q&A interface for this query.  Query editor is not an option.  I will provide sample queries to business users who doesn't have any SQL skills. I can't find any appropriate phrase to replicate Left Outer join in Power BI Q&A .

     

     

     

     

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi mehmetpowerbi,

      Actually, you can do it in Power BI desktop as dilumd said, then publish it to Power BI service. Then share the dashboard to your business users.

      Best Regards,
      Angelia