Forum Discussion
Dataflow Refresh Error (Merge Queries)
Hi everyone, a dataflow is failing to refresh all of a sudden, since last week. I'm getting this error: Error: Data Source Error : DataSource.Error: Microsoft SQL: Invalid object name 'schema$...
Anyone experiencing Dataflow refresh failures should try this fix. Edit the DF settings and disable the "Enhanced compute engine settings." Then apply and let it make the changes. Then try a refresh.
I had the same issue in recent weeks.
However, there is a setting saved my queries.
Go to edit dataflow, under the Home tab, there is an button called "Option". Open the "Project options".
Tick on the second option, "Allow combining data from multiple sources, This could expose sensitive or confindential data to an unauthorized person". Then, try to refresh your dataflow. At least, my one works now.