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

Need to remove all record of a Data Source from report in PBI Desktop

Hi All

New to PowerBI so forgive if this is something simple.
I have developed a report in Power BI desktop and published to the Service.
During the course of the development of the report, various data sources were created and used and removed when found to be actually not needed.

I have installed an On-Premise Gateway to faciliatate overnight refreshes of the data.

Problem is I am unable to schedule a refresh as the Gateway has a Status of "Not confiugured correctly" and is listing all the old no longer used (and removed form the PBI Desktop report) Data Sources.
How do I remove all remnants of these old no longer used (and beleived to be deleted) data sources.

They aren't listed in Data Source Setitngs.

In the case of ODBC connections, the ODBC connection has been removed from ODBC on my machine and the Report refreshes fine thus there can't be any reference to those removed ODBC connections in the report as it would fail.

There has to be a solution.  Surely I can't be expected to keep every data source ever created in a report.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team
Community Support Team

Re: Need to remove all record of a Data Source from report in PBI Desktop

Hi @HeyThere ,

You could refer to below link to manage your gataway:

https://docs.microsoft.com/en-us/power-bi/service-gateway-manage#remove-a-data-source

 

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HeyThere Frequent Visitor
Frequent Visitor

Re: Need to remove all record of a Data Source from report in PBI Desktop

Ok. It seems it just needed time.
A LOT of time.

4 days later, it just sorted itself out.  The removed Data Sources disappeared.
I did nothing.

It seems some things (this isn't the only issue I've had sorted with time, a LOT of time) take time so just work themselves out in Power BI.

Disappointing.  Especially when compared to other BI platforms. 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Need to remove all record of a Data Source from report in PBI Desktop

Hi @HeyThere ,

You could refer to below link to manage your gataway:

https://docs.microsoft.com/en-us/power-bi/service-gateway-manage#remove-a-data-source

 

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HeyThere Frequent Visitor
Frequent Visitor

Re: Need to remove all record of a Data Source from report in PBI Desktop

Ok. It seems it just needed time.
A LOT of time.

4 days later, it just sorted itself out.  The removed Data Sources disappeared.
I did nothing.

It seems some things (this isn't the only issue I've had sorted with time, a LOT of time) take time so just work themselves out in Power BI.

Disappointing.  Especially when compared to other BI platforms.