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?
