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.
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:
- open report in Power BI
- SAVE AS to new report (this step is critical – wont work from the original report)
- In Advanced Editor, make some minor change to the query string(s) (I generally use custom SQL in my queries).
- SAVE and SAVE AS to original report name
- Publish original report. Should be ok now.
- Edit report to undo minor change and republish.
True Solution Found!!
- Got to Query Editor
- Open Data Source Settings
- Select the source to be removed
- Select "Change Source"
- 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. - Click OK to accept the change.
- Power BI recognised the duplication and removed the duplicate entry.
I hope this works for you.