You’re offline. This is a read only version of the page.
28
Thanks @Drrickryp,
I made it work!😀
As I will be importing about 25 tables from SQL Server with also approximately the same number of relationships it would be nice if you can script this, instead of doing it all by the GUI. Make it repeatable.
Any ideas or suggestions over there?
Kind regards,
Piet
Hi @Drrickryp
I followed the link to your article in the COmmunity blog on how to create the relationships, but am unable to find the right article...🙄.
I also would like to etablish relationships between tables for imported data from SQL Server into the Dataverse.
Thanks
Piet
Hi @lazevedo and @AbeSaldana
I have been struggling with bringing a large dataset from an outside database into CDS while maintaining the relationships between the tables. It has even been stated that it is impossible to do it. https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/Creating-Parent-Child-Relationship-... I have just posted an article in the Community blog https://powerusers.microsoft.com/t5/PowerApps-Community-Blog/bg-p/PowerAppsBlog with a step by step method for accomplishing this with illustrations of the steps. It might be cumbersome but it is possible just using Excel with the built in Power Query, PowerApps Common Data Service. Kudos goes to @SeanHenderson for the original idea.
Hi @AbeSaldana
Can this be done at the time the data integration for the child table is done? If not, can it be done in bulk following integration of the two tables using Power Query? I have a child table containing over 20k items and it is impractical to relate each item one at a time.
lazevedo,
you need to create the fields that are for the FK as lookups on that entity, and then associate those records with the lookup field, that will create the relationship you need to for those 2 entities.
hope that helps
abe.
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
