Forum Discussion
Obsolete data sources in dataflow lineage
I know this is an old post, but figured I would share something that worked for me...
One thing that I did to remove old SQL connections on a dataflow was when EDITing the existing table on the dataflow, I went into OPTIONS > PROJECT OPTIONS, changed the DATA GATEWAY to "(none)", clicked OK.
I then received a "Credentials are required to connect to the SQL source" error message on the query.
I went back into OPTIONS > PROJECT OPTIONS, changed the DATA GATEWAY back to the correct gateway that contains the connection.
Received a "We could not evaluate this query due to invalid or missing credentials" message.
Clicked on CONFIGURE CONNECTION...the connection to my correct gateway popped up, I clicked on CONNECT, and then clicked on SAVE and CLOSE.
After the validation completed and I closed the power query editor screen and dataflow, the lineage view no longer contains the old connections and it only contains the current active connection.
I did this successfully on 20+ dataflows that recently had a SQL server change (same query, just new server name).
Hopefully this helps.
This worked for me too, with one small modification. It actually wouldn't allow me to change the gateway to "None." I tried several times, but every time I clicked "OK", it automatically reverted back to the same gateway that was selected before. What actually worked was changing it to a different gateway, and then changing it back again. Thank you for pointing me in the right direction!