cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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?

2 REPLIES 2
Highlighted
Community Support
Community Support

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:

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-import-export

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-cds-newentity-pq

 

 

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.
Highlighted
Regular Visitor

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

Announcements
Check this Out

Announcing

Class of 2020- Season 2

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (8,207)