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

Re: Remove existing DataSource

I have been trying for 1 week to get a previous link removed from the datasource.  This workaround works - Yippe


@Anonymous wrote:

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.

 

sfmike99 Frequent Visitor
Frequent Visitor

Re: Remove existing DataSource

 

Well I didn't do the "save as" trick but I did delete the old report and dataset from Power BI Service, then re-uploaded it again. New version works fine, however I had to recreate permissions (a pain) and I still have the old data sources listed. Even if "save as" works, it still seems like a bad solution because it is effectively a new report. All this to change a file pointer?

 

Please add 'delete' options for data sources to Power BI Service!

Highlighted
Foram Frequent Visitor
Frequent Visitor

Re: Remove existing DataSource

How to delete one of the data source credentials of sharepoint link from power bi service

 

 

Foram_2-1572431917038.png

i  tried changing data source and clearing the permissions in desktop, but didn't work.

 

 

 

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)