Forum Discussion
Dataflow Refresh Fail Since it Refers to Another Entity
I'm trying to move a dataset up to a dataflow and transferred everything by simply copying the advanced editor and pasting it into blank queries within the dataflow query editor. After doing this...
Long article that helped explain what's going on:
https://radacad.com/workaround-for-computed-entity-in-power-bi-pro-dataflow-in-power-bi
Essentially if the results of the query contain complex data types (lists, tables, records), or refers to linked entities, the intermediate query should be disabled for load. This will also prevent the complex types from being reduced to csv-compatible types like text and number (which most likely can't be performed, resulting in nulls). If you already tried to load the intermediate query, open it in advanced editor and you'll see the "Remove Errors" and related steps that can be then commented out or removed.
Don't forget to update the last "in" to point back to the original last step.