Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
setis
Post Partisan
Post Partisan

Deleted main dataset

I deleted the main dataset of several reports with a live connection to this dataset. 

This was as an attempt to fix an issue with the gateway, but it was pretty stupid now that I realize that. 

 

I uploaded the same dataset again to the same workspace with the same name. 

 

All the reports live connected to this dataset disappeared. The problem is that I can't even open the pbix files for these reports in desktop. I get this  "Unable to connect" error. 

errr.PNG

 

When I click on "Edit" nothing happens. 

 

Is there a solution for this or do I have to rebuild all these reports again?

 

1 ACCEPTED SOLUTION
veganEarth
Frequent Visitor

I just had this exact same problem! I think there is something wrong with the current versions of the Desktop as in the past you could point to another dataset if you blew away the source file.

 

This seems to be a recurring issue as I found this thread from 2017:

https://community.powerbi.com/t5/Issues/Data-Source-published-in-Power-BI-Service-deleted-PBI-Deskto...

 

The only solution I could come up with was rolling back the Desktop version. I used version May 2019 and I was able to point the reports to the republished data source. You may be able to use a later version but this was the one I had lying around.

 

Good luck!

View solution in original post

4 REPLIES 4
setis
Post Partisan
Post Partisan

thanks a lot for your help @veganEarth it worked. 

veganEarth
Frequent Visitor
veganEarth
Frequent Visitor

I just had this exact same problem! I think there is something wrong with the current versions of the Desktop as in the past you could point to another dataset if you blew away the source file.

 

This seems to be a recurring issue as I found this thread from 2017:

https://community.powerbi.com/t5/Issues/Data-Source-published-in-Power-BI-Service-deleted-PBI-Deskto...

 

The only solution I could come up with was rolling back the Desktop version. I used version May 2019 and I was able to point the reports to the republished data source. You may be able to use a later version but this was the one I had lying around.

 

Good luck!

@veganEarth thanks for your quick reply. I'm dying inside.. Where do I find a May 2019 (or earlier) version of power BI??
Edit. I found a link

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.