Forum Discussion
Can you remove a dataflow datasource when it is no longer used in the dataflow?
I have created several data flows using azure blob storage and then linked them to another data flow that combines them via linked entities. I do some transformations from queries that reference the...
SGriga
Advocate I
Advocate II thought that I found a solution here: https://learn.microsoft.com/en-us/power-query/dataflows/troubleshooting-dataflow-issues-connection-to-the-data-source#deleted-or-old-data-sources-still-show-up
... alas, it did not work for me. Maybe it will work for someone else.
It is the end of 2022 and we still have this issue...
Hi, your solution worked for me when it came to database connections (i.e. ODBC, Redshift, SQL, etc) but not for web connections, such as sharepoint links. I did find a method that worked for me, so hopefully it could help you or others:
- In your workspace, click on the cog at the top right and select Manage connections and gateways (should be under the Resources and extensions header)
- In the Data (preview) page, go through all the data connections and find the one that you want to remove
- Select it by clicking on the radio button on the left
- Scroll back up to the top of the page and click Remove to remove
- Repeat for each additional data connection (yes, you can only do this one at a time)
Hope that helps
