Forum Discussion

suoko's avatar
suoko
Regular Visitor
8 years ago
Solved

Many to Many relationship

Hi,   I'm trying to restore my memories about dbs back into place. I got two simple tables and I want them to be "connected"   TABLE 1 user 1; group 1 user 1; group 2 user 2; group 2 user 2;...
General Comment
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi suoko,

     

    Based on my test, you should be able to simply use the Merge Queries option in Query Editor to get the expected result in your scenario. For more details about how to use Merge Queries option with Power BI, you can refer to this article. :smileyhappy:

     

    Regards

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

Hi suoko,

 

Based on my test, you should be able to simply use the Merge Queries option in Query Editor to get the expected result in your scenario. For more details about how to use Merge Queries option with Power BI, you can refer to this article. :smileyhappy:

 

Regards