cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
majort Frequent Visitor
Frequent Visitor

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 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

1 ACCEPTED SOLUTION

Accepted Solutions
jeremyfirth Frequent Visitor
Frequent Visitor

Re: Remove existing DataSource

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.

View solution in original post

12 REPLIES 12
Super User
Super User

Re: Remove existing DataSource

In Power BI Desktop, File | Options and Settings | Data Source Settings

 

Highlight the data source and hit "Delete"


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

majort Frequent Visitor
Frequent Visitor

Re: Remove existing DataSource

The problem is that in the data source settings only 1 connection is listed. When i upload the pbix to the service, 3 connections are listed in the data sets schedule settings.

jeremyfirth Frequent Visitor
Frequent Visitor

Re: Remove existing DataSource

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.

View solution in original post

jimmyhaley Frequent Visitor
Frequent Visitor

Re: Remove existing DataSource

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.

mmedina New Member
New Member

Re: Remove existing DataSource

To get that to work you need to Edit the Queries directly.

In my case I had connection strings in there, I updated them to a valid one.

Then you need to Publish to Power BI from the Desktop app.

Simply uploading the pbix file will not fix the issue.

andylitics Frequent Visitor
Frequent Visitor

Re: Remove existing DataSource

We recently moved a SQL server, and I updated the location in Data Source Settings screen succesfully in the query.  Everything works fine when i refresh locally from PBI Desktop.

 

After publishing to Powerbi.com though, similar to the OP, the old data source still shows up in the Data Source Credentials screen, even though i've confirmed my data model doesn't reference it at all.

 

Tried everything outlinded here, I've deleted the data model, uninstalled and reinstalled the personal gateway, and uploaded the data model via both "get data" as well as "publish" and nothing seems to work.

 

Now my refreshes can't be scheduled since it thinks there is still some kind of reference to it, but if there was, how could the file refresh locally with no issue?

 

Any input/suggestions would be appreciated.

Anonymous
Not applicable

Re: Remove existing DataSource

Facing the same issue but it only affects some reports.

 

Looks like this happens when you have a query that references another query (that was originally using the old data source).   The referencing query appears to maintain some link to the old source.

 

Workaround:

  1. open report in Power BI
  2. SAVE AS to new report (this step is critical – wont work from the original report)
  3. In Advanced Editor, make some minor change to the query string(s) (I generally use custom SQL in my queries). 
  4. SAVE and SAVE AS to original report name
  5. Publish original report.   Should be ok now.
  6. Edit report to undo minor change and republish.
Highlighted
Manninda Frequent Visitor
Frequent Visitor

Re: Remove existing DataSource

True Solution Found!!

  1. Got to Query Editor
  2. Open Data Source Settings
  3. Select the source to be removed
  4. Select "Change Source"
  5. change the source to be the same location as one of your other sources. 
    My situation was one source was a local copy of a Sharepoint file, the other was the sharepoint URL.
  6. Click OK to accept the change. 
  7. Power BI recognised the duplication and removed the duplicate entry. 

I hope this works for you. 

Manninda Frequent Visitor
Frequent Visitor

Re: Remove existing DataSource

True Solution Found!!

  1. Got to Query Editor
  2. Open Data Source Settings
  3. Select the source to be removed
  4. Select "Change Source"
  5. change the source to be the same location as one of your other sources. 
    My situation was one source was a local copy of a Sharepoint file, the other was the sharepoint URL.
  6. Click OK to accept the change. 
  7. Power BI recognised the duplication and removed the duplicate entry. 

I hope this works for you. 

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)