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

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

You may be able to do that join in Power Query but you could also create a bridge table to do it I believe. And then it is just tabular relationships.