Forum Discussion
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.
Community ChampionIn Power BI Desktop, File | Options and Settings | Data Source Settings
Highlight the data source and hit "Delete"
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.
jeremyfirthAdvocate II
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.
jimmyhaleySo...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.
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.
Hi Jeremy,
I hit the same problem. Can you please share how we can remove the network path from the data source settings. I selected the path in the data source setting but it only clears the permission.
