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.
Hi Everyone,
I found one solution.
Go to PowerBI Desktop->Home->Transform data-> Data source Settings.
Once the Data source settings Dialog opened.
select Data sources in current file Radio Button. select each data source that you want to remove and click on change Source button at the bottom, then update the settings as per the required data source and update then automatically powerbi removes the duplicate data sources. Finally you left with one datasource that is required for you. If this resolves your solution then click on Accepted Solution.
Thanks Everyone
That is the only thing that worked for me.
