Unable to Open Document; We weren't able to restore the saved database to the model

[jesper_sommer]

I just updated to the latest version to take advantage of the new features; but it has busted a bunch of my report files. Whenever I open a previously created report and save it (even with no changes what so ever) the file becomes unusable, with the error "Unable to Open Document We weren't able to restore th saved database to the model" thrown at launch. The files were created with Power BI Desktop 2.39.4526.362 and my projects get corrupted when saving them using Power BI Desktop 2.40.4554.361 The projects work in the latest version until the file is saved and Power BI Desktop is closed, but any attempt to reopen the file will throw the error. I have reverted to version 2.39.4526.362 and do not experience this issue any more, so I'll have to do my customer case with the older version (which is annoying since I really wanted to use the Top N filter). Upgrading to 2.40.4554.361 promptly brings the issue back. This issue was previously reported, but apparently marked as "closed" with no further discovery, as seen on this URL: https://ideas.powerbi.com/forums/360879-issues/suggestions/15693186-unable-to-open-document-we-weren-t-able-to-restore#comments From messing arround with the files I would speculate that the error is related to a corruption of the model metadata; I managed to provoke various errors where the application seemed to think that the model could not be saved because existing entities with the same names already existed. I have sent "frowns" with those errors, with the trace files attached. I am happy to provide the actual report files for further diagnosis if required, as the data is not very sensitive. Just please don't dismiss this issue without looking into it. Thanks

[fbcideas_migusr]

While the PBI Desktop issue appears to be resolved by the latest build, myself and others are getting an "error: (404) Not Found" when publishing an unchanged model from PBI Desktop I also get Status 500 error when using Get Data from app.powerbi.com: Activity IDbd265ad6-bff3-436c-ba58-0c5054afe37b Request ID65779f80-6b32-f06d-c8ea-e8397947e39b Correlation ID1645b9bb-ea14-f24a-6f15-56188c1641cb Status code500 TimeSat Nov 05 2016 10:11:42 GMT+1100 (AUS Eastern Summer Time) Version13.0.1700.537 Cluster URIhttps://wabi-south-east-asia-redirect.analysis.windows.net It seems clear the PBI Desktop fix has not been applied to app.powerbi.com. The trigger seems to be a pre-existing Measure that has the same name as a Table. It seems you do not have to modify the PBIX file to strike this error.

[fbcideas_migusr]

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.

[fbcideas_migusr]

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.

[andrey7]

The same is here.

[a_hyland]

All of our files will now not open and when reverting back to the old version the data will not refresh. This is a catastrophe for ourselves and our customers who now cannot use Power BI as required.

[damien3]

Hopefully there is an update to this, as I have just encountered the same issue.

[permichal0]

happens to me also.

[nbailey]

I downloaded the latest version (2.40.4554.463) and I too am now able to open the Desktop file again (and save it and still open it after). However now I have received an error trying to publish it: Publishing failed for an unknown reason. (FailedtoRefreshPackageAfterImportError)

[pbiideas1]

I'm experiencing the same issue.

[nbailey]

Experienced the same issue here - my file is now inoperable...