Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Loading data into a many-to-many entity

Hi everyone, I am having trouble loading data into many-to-many entities.  I have created various many-to-many relationships in my model, using both standard entities and custom entities.  After having done that I want to be able to load data into the relationship entity created by CDS.  Using Power Query I get to the "Map Entities" screen and I was expecting the relationship entity to appear in the "Destination entity" drop down box but I don't see any of the many-to-many tables.  Any suggestions?

Community Support Team
Community Support Team

Re: Loading data into a many-to-many entity

Hi @jbul ,

Do you want to import data with relationship?
I've made a similar test and found that I could find entities with relationships when field mapping.

Please note that the custom entity's name is : "crb4c_...."8201.PNG


What's more, here are some docs about data integration for your reference:



Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Level: Powered On

Re: Loading data into a many-to-many entity

Yes, I too can see the entities that have many-to-many relationships.  What I am not able to see is the junction table that is created by the CDS to house the relationship.  In my case I have 2 custom entities: Clinic and Employee, and there is a many-to-many relationship between them.  When the relationship is created CDS tells me that there is a relationship entity called cr9f8_employee_clinic.  But in the Power Query screen I don't see cr9f8_employee_clinic in the target entity drop down list.

Helpful resources


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Microsoft Learn

Learn how to build the business apps that you need.

Users Online
Currently online: 199 members 5,656 guests
Please welcome our newest community members: