Forum Discussion
Gateway Connection Cleanup/Remove unused data source connections
Try one more thing. When you go into your Dataflow editor head over to the options then Project Options.
In your project options set your gateway to none then click ok. You'll see a message that tells you that credentials are required to connect to the source.
Now head back to project options and change your gateway from none back to your gateway. The message will still tell you that credentials are required to connect. So click on the configure connection button then click connect. Make sure that all of your queries icons are back to table icons and not:.
Save and check the credentials section again. See if that does it for you. If it doesn't work then export the JSON file for the Dataflow
Start a new dataflow in a different workspace and do Import Model
It'll need you to configure credentials then save it. Check to see if you see it there. If so then there is something in the actual JSON that is causing it. Not a solution yet but it'll tell you whether the actual file is holding the info for the phantom connection.
I went into the power query editor for the dataflows and then saved immediately. The sources are still showing. I have 21 tables in the dataflow (Single Source, but different tables, Our SQL server has 200+ tables). I checked the m language for each power query per table and all are referencing the same connection (the green one). I can't find any connection in the dataflow that references the other connections. I think this is why refreshes have been solid and no refresh errors. This stinks because I have 10-15 reports that pull from this dataflow so reimplementing the dataflows would be labor intensive.
Try one more thing. When you go into your Dataflow editor head over to the options then Project Options.
In your project options set your gateway to none then click ok. You'll see a message that tells you that credentials are required to connect to the source.
Now head back to project options and change your gateway from none back to your gateway. The message will still tell you that credentials are required to connect. So click on the configure connection button then click connect. Make sure that all of your queries icons are back to table icons and not:.
Save and check the credentials section again. See if that does it for you. If it doesn't work then export the JSON file for the Dataflow
Start a new dataflow in a different workspace and do Import Model
It'll need you to configure credentials then save it. Check to see if you see it there. If so then there is something in the actual JSON that is causing it. Not a solution yet but it'll tell you whether the actual file is holding the info for the phantom connection.
That worked. Thanks. Only the one datasource is showing.
The first steps in the process with removing the datasource in project options is what did it. Once I removed and then reapplied, it worked well