Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How do I create a power query with a many-to-many mab table?

I need to add records to a many-to-many table! 

What I did:

I created a many-to-many relationship in the account table to the division (custom) table. This creates a hidden table which has a many-to-one relationship to both, as the MS Documentation explaines it. 

If I take a look into the backend with the xrmtoolbox, I can see the hidden table which is created through the N:N relationship.

 

 

 

Now I want to select the table in the mapping stage of the power query. But unfortunately I can't see the table, so I'm not able to select it. 

 

How is it possible to map data to a N:N table or relationship?

Need Help

1 Reply

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous ,

    Not familiar with this source, how did you create these tables and relationships by tools? 

    This creates a hidden table which has a many-to-one relationship to both, as the MS Documentation explaines it.

    Could you please consider sharing the document about this thread

     

    In addition, if a table which is hidden in the data source before connecting to it in Power BI Desktop, the hidden table would not load in Power BI. Whether there is a way to unhidden the table in this data source.

     

    Best Regards,
    Community Support Team _ Yingjie Li