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

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Users online (66,648)