Remove existing DataSource

[majort]

Hi,

if i change a data source for example from one database to another database by editing the M Script, the previous used database connection still exists because when i publish the pbix to powerbi.com then the old database connection i still listed in the data sources.

The problem is that i cannot remove this data source and the impact is that i cannot schedule the dataset because of the old database connection (this was only a development database that does not exists anymore).

So how can i remove a database connection or data source that is not anymore used by any dataset?

thx in advance

[jimmyhaley]

So...this is not a solution, this is a workaround.

The problem remains that if you delete a datasource from your PowerBI Desktop file, it remains (forever, as far as I can tell) in the upload.  Deleting a dataset and reuploading it is a huge pain when you have a minor dataset tweak (such as moving the dataset to new drive or different folder).  This needs to have a true solution before it is marked as solved.

[aacptl]

In case anyone needs this still...

(1) Go to transform data.

(2) on the left, under queries, right click the data set you want to remove, and select delete.

[JofrainVisda]

That's deleting a table not a datasource bro.

[mpcosmin]

I don't know if this topic is still opened but I've found that if for example I have a server as a source and let's say a local excel that I need to delete from the data sources, I click "change source" form the excel file and paste the main server on top. Click ok and it will only show the server now. Since is "doubled"