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

[Anonymous]

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?

[v-yingjl]

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