Forum Discussion

majort's avatar
majort
New Member
11 years ago
Solved

Remove existing DataSource

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 powe...
  • jeremyfirth's avatar
    jeremyfirth
    11 years ago

    had this same issue when I created a link to a file on a mapped network drive initially, then later changed it to the full network path to the file.

     

    Both data connections were showing up when I either published it to PowerBI.com or when I went to PowerBI.com and tried to pull the file instead. 

     

    I ended up deleting it from PowerBI.com, re-downloading and installing Personal Gateway, then pulling the file into PowerBI.com using Get Data.

     

    Kind of a pain, but it worked. It was a solution offered by a Microsoft employee in another thread.

aacptl's avatar
aacptl
New Member
3 years ago

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's avatar
JofrainVisda
Advocate I
2 years ago

That's deleting a table not a datasource bro.

  • mpcosmin's avatar
    mpcosmin
    Frequent Visitor
    2 years ago

    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"