Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

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
Community Support

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.

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

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Users online (4,869)