I’m developing a cloud flow to run a query against a Power BI Data Set (Run a Query Against a Data Set Action) and load the results into a Dataverse table. The data set I’m pulling has 25 columns and 2500 rows. This flow has been working fine until I changed the columns included in the data set. I removed 1 column and added 4 new ones.

Has anyone dealt with this before?

More Info:

Power Automate exposes the firstTableRows array from the action’s response body. Since making the change above, I still receive all the rows, but several columns are now missing, and some are in a different order that specified in the DAX query. The new columns are all present where they are supposed to be. 7 columns from the original query are no longer in firstTableRows section. Interestingly, there is an additional set of nested arrays in the response that is not exposed as an output in Power Automate (body/results/tables/rows). It seems to contain all of the data.