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 Specialist
Solution Specialist

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 Specialist
Solution Specialist

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

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (29,207)