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'm having the exact same issue with a dataflow that has been built in March and remained unchanged since then.
No changes to the database either.
Seems that the merging tables step is searching for a table in the SQL Database when it should just take the reference of the custom table that has been created in the same dataflow.