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...
for what it's worth none of the above suggestions or other help articles resolved my version of this issue.
for me, the issue was that i had created a small manual table in the dataflow directly to join to for the purposes of both filtering and cleaning/mapping some strings in one step (i.e. left join on key columns and bring in only the new "clean" column from this table). apparently the dataflow is not capable of this join between a table in the dataflow and a source from MS SQL Server.
I have other joins to tables based on csvs hosted in sharepoint which work without issue.
just another example of a frustratingly vague and multi-purpose error message and limitation from microsoft in this ecosystem