cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
QuantumRemedy
New Member

Correct way to handle cyclic dependency errors in a dataflow

I'm new to using dataflows and my plan is to use one or more dataflows to copy Dataverse data for my Power Portal from one environment to another using an oData connection.

 

I have one dataflow with a lot of Portal entity queries in it, including adx_webpages and adx_contentsnippets. When I try to run the dataflow, I get the following error:

 

There was an error while evaluating relationships. Details: Cyclic dependency detected between the following queries: [adx_webpages] [Entity: adx_contentsnippets]

 

If I remove adx_contentsnippets and put it in a separate data flow and then put adx_webpages in another dataflow, they run fine without issue, so my assumption is that the queries are either running async and that's a problem with cyclic dependency, but if their in their own dataflow, it doesn't care what's in the other table? Either way, if I just remove these from my dataflow with all of the queries, I get more cyclic dependencies so it seems I will have to have maybe 5-10 dataflows to accomplish what I need.

 

I also tried adding the different tables as separate "navigations" to a single query using the advanced editor, but I can't do field mapping and I'm not sure that is even doing what I think it is doing at all...

 

Is there some way I can use the advanced editor or some other feature to load these tables in synchronous steps or is the best way to create a new dataflow for each entity affected by a cyclic dependency?

1 ACCEPTED SOLUTION

Accepted Solutions
Fubar
Solution Sage
Solution Sage

Think you may end up with additional issues trying to do this via dataflows, are you aware that Microsoft provide the Data Migration Tool and a Schema file to help you move your Power Apps Portal data from one environment to another?  https://docs.microsoft.com/en-us/powerapps/maker/portals/admin/migrate-portal-configuration

 

View solution in original post

2 REPLIES 2
Fubar
Solution Sage
Solution Sage

Think you may end up with additional issues trying to do this via dataflows, are you aware that Microsoft provide the Data Migration Tool and a Schema file to help you move your Power Apps Portal data from one environment to another?  https://docs.microsoft.com/en-us/powerapps/maker/portals/admin/migrate-portal-configuration

 

View solution in original post

Nope, I did not know about that. The Data Migration Tool appears to be what I need. Thanks!

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,740)