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

Importing to CDS with relationships

Hello!

 

I've got a unique problem that I've been unable to locate a soution for.  I'm working to create a dashboard of data coming to CDS from the Microsoft Graph, specificly targeting data from our Azure Active Directory instance.  I'm using the data integration facilities to accomplish the lift of info from Graph to CDS.

 

One of the first things I wanted to be able to show was group membership.  So, I've created the entities in CDS that consist (at a high level) of People, Groups and GroupMembership.  I've also got the appropriate relationships setup between those entities.  Now I'm at the point of pulling in the data that shows "who's in what group?" and I'm having a hard time making the data fit such that it meets the relationship criteria that was setup in CDS.

 

Has anyone attempted to import data that they've been able to transform to meet the relationships between the new entities?  Any help would be appreciated!

 

Thanks in advance,

 

Scott McCarty

Executive Director, IT

OPTiMO 

6 REPLIES 6
Community Support Team
Community Support Team

Re: Importing to CDS with relationships

Hi @ScottMcCarty,

Do you want to import data into CDS entity with relationships?

Please check and see if the following article would help in your scenario:

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/relationships-overview

More details about importing data into CDS Entity, please check the following article:

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,

Kris

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

Re: Importing to CDS with relationships

Hi!  Thank you for replying.  I have reviewed those items, but they are not meeting this particular scenario (or I am missing the important nuggets).  Let me boil this down to a simple use-case of what I'm looking for:

 

I am building a custom, model driven app built on CDS for our management team to be able to manage particular user data, but also to be able to go easily gather information.  One basic example of this is that I would like to show user and group membership.  Using an ODATA connector to the Microsoft graph, I am able to retrieve the users, and I am also able to retrieve groups and their member IDs.  I load each into their own custom entity -- this part works well.  The problem comes in when I want to create the table that contains the many-to-one relationship from an entity (call it GroupMembers for purposes of this dicsussion), but when I attempt to load that data, I can't force the lookups to occur, nor can I reference my own pre-loaded IDs from users and groups. 

 

If I'm missing somethign obvious, I'd love to get your feedback.  And, if it's just not possible on the current version, I'd love to know that as well.

 

Thank you for taking the time to read this post,

 

Scott

Highlighted
Super User
Super User

Re: Importing to CDS with relationships

Hi @ScottMcCarty and @v-xida-msft and @TopShelf-MSFT  and @Shanescows ,

I have encountered the same problem as you have and the above references are unsatisfactory. I asked the question again here and did not get a good answer. Visualizing-data-in-CDS-Model-driven-app Is there anywhere that gives a step by step approach to importing data into CDS entities from related tabular data (Primary and Foreign keys)  that preserves the preexisting relationships? If there is, I haven't found it.  I am trying to create a model driven app for a client from this kind of data.  In my opinion,  the inability or difficulty required to maintain pre-existing relationships is hindering the wider acceptance of Model Driven Apps in PowerApps.  If there is a method for doing this, it would make a good video presentation. 

bettc
Level: Powered On

Re: Importing to CDS with relationships

Im having the same issue at the moment

 

how are people getting exiting app data into CDS if they cant bring in relationships?

i have near millions of PK:FK relationships so i cant use Model Driven as there is no way to import them?

 

that just seems a bit weird

barlowse
Level: Powered On

Re: Importing to CDS with relationships

I have been unsuccessful in getting data into the cds entities where relationships are defined. The only way I got my data over was to use flow, and create new records, letting the system assign the associated guid. Really not optimal, but I was copying from a cds production environment to a development environment. Every time I tried to use the import - I got data type mismatch -string <-> guid. I assumed that it was my related entity guid...

Dayananthan
Level: Powered On

Re: Importing to CDS with relationships

Exactly i also have the same question @v-xida-msft but didn't able to find any examples?

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 367 members 6,653 guests
Please welcome our newest community members: