I have a PBIX file which has been published to our team's PowerBI workspace for months now, and which I was able to edit and publsih as recently as yesterday.
This morning I updated PowerBI Desktop to version 2.40.4554.361 64-bit (October/2016), after which I opened the previously mentioned report file, made some changes, and then tried to publish them. I couldn't publish it, and instead got the following error: "Publishing failed for an unknown reason (FailedToRefreshPackageAfterImportError)".
So I tried closing and restarting PowerBI, but now I can't open the PBIX file anymore. I get the error "We weren't able to restore the saved database to the model".
Any ideas whether I can fix this or if that pbix is now dead? Thanks.
I met the same problem after the program update. I thought it is because of the gateway issue, so I reset my gateway and PowerBI, but finally it does not work.
So I hope someone can help with us for this issue.
@DBDave This isn't the first post I've seen today on this issue. You could install last months version of the Desktop, it should be in your downloads folder unless you intentionally delete those. If you need a copy, I can provide you with a OneDrive link to get any of the previous versions.
Thanks for the link, unfortunately I can't open the file with the older version as it complains about the file being incompatible with the current version and says to download the latest version. :tableflip:
Oh well, guess I'm going to have to try to recover an earlier version of the pbix file.
These issues appear to be related:
One of my files is now unopenable - I had to restore from a backup.
Very poor regression testing to let this get through - it seems clear more time and effort should be put in to testing before each release.
I'd be happy if the pace of new features each month slowed down, if that meant we had a more stable and reliable product to use.
Publishing failed for an unknown reason (FailedToRefreshPackageAfterImportError)
Adding to other post, please use “Send a Frown” in Power BI Desktop to report your issue, also vote for this issue in the idea that mike_honey provides.
Besides, regarding to the above error, I have ever got it in the following scenario: I apply Row Level Security(RLS) on my dataset, publish the PBIX file to Service, and pin visuals to a dashboard. Then if I republish the PBIX file to Service, the error occurs. However, once I delete the visuals from dashboard, I can successfully republish the PBIX file. If you get the above error message in other PBIX files, please check if you encounter the same scenario as mine.
I heard just now that there is a new build available on the download page to fix this issue.
I've tested it and it does avoid the "A measure ... already exits" issue that I encountered. With that new build, I was also able to open a file which was saved after striking that error, which previously gave an error: Unable to Open Document We weren't able to restore the saved database to the model
Please still take careful backups of your files and dont rely on this - I have conducted a very limited test for one scenario.
Here are the version numbers:
2.40.4554.421 - has issues
2.40.4554.463 - new build
Can others please test and post your results.