Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
When I click on "Edit" nothing happens.
Is there a solution for this or do I have to rebuild all these reports again?
Solved! Go to Solution.
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:
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!
Older versions can be found here:
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:
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!