cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Microsoft v-danhe-msft
Microsoft

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.

View solution in original post

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. 

View solution in original post

2 REPLIES 2
Microsoft v-danhe-msft
Microsoft

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.

View solution in original post

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. 

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,128)