Can't remove datasource from Dataflow

[Anonymous]

Hello,

I have a BI dataflow which is using a view from a sql database. We migrated the database, so I've changed in the dataflow the source from the old server with the new one.

The problem is that the old server still appears in the lineage, together with the new server. And also now I have 2 gateways instead of one: one pointing to the old server and the other to the new one.

Didn't find a way to remove the old connection nor the gateway.

The dataflow must be connected only to the new server, not to both. Is there any possibilty to fix this and delete the old one?

Thank you,

Mihai

[v-robertq-msft]

Hi, 

I think you can go to the original data source's data source setting->Users to remove the user account of the data flow owner to make the dataflow must be connected only to the new server instead of the old one.

Please refer to this link:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources#remove-users-fro...

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[arvindsingh802]

Its a bug from, as a workaround remove Dataflow owner from Datasource user list it will resolve the issue.

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!

[Anonymous]

What does it mean by removing dataflow owner from user list?

[arvindsingh802 · Accepted solution]

Remove the user from Gateway data source (Old) user list, so user will not have access to use the data source anymore and it will also fix this issue.

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!