Skip to main content

Issues

Completed

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

Vote (15) Share
Jesper Sommer's profile image

Jesper Sommer on 01 Nov 2016 05:46:13

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

Administrator on 18 Nov 2016 00:48:20

Sorry for the trouble - we had a bug related to reports containing measures with the same name as a table in the model. We've since fixed this in Power BI Desktop and the Power BI Service. Please download the latest build of Power BI Desktop from powerbi.com and try again. Thanks for your patience.

Comments (20)
Jesper Sommer's profile image Profile Picture

Nate on 05 Jul 2020 22:33:34

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

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

Jesper Sommer's profile image Profile Picture

Mike Honey on 05 Jul 2020 22:33:33

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

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.

Jesper Sommer's profile image Profile Picture

Mike Honey on 05 Jul 2020 22:33:33

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

Same issue - trashed my file so I had to revert to a backup. The error reported is: "A measure, set, expression or data source with the name of "TableName" already exists in the 'Model' Model. It's been reported also here: http://community.powerbi.com/t5/Desktop/After-upgrading-to-Oct-30-2016-I-cannot-refresh-my-model-anymore/m-p/85398

Jesper Sommer's profile image Profile Picture

Ken on 05 Jul 2020 22:33:32

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

This is serious. I have the same problem.

Jesper Sommer's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 22:33:30

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

I'm experiencing the same issue.

Jesper Sommer's profile image Profile Picture

Power BI User on 05 Jul 2020 22:33:30

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

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

Jesper Sommer's profile image Profile Picture

Jesper Sommer on 05 Jul 2020 22:33:30

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

Hi Alex, thanks for looking into this. I have shared a OneDrive folder with your provided e-mail address as the file is too large to send by e-mail. Feel free to contact me if you have further questions, or if there is anything further I can help with.

I have included the data files in the shared folder in case you need them. Their original location is a subfolder in my Documents folder so you need to update the references in the report, or create a new folder with the corresponding path (I'm sure you know how to handle that already :o) )

Jesper Sommer's profile image Profile Picture

Jesper Sommer on 05 Jul 2020 22:33:30

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

To other posters: I have not identified a solution to this. I reverted to a previous version of my file (as experience has taught me to keep multiple versions) and downgraded to the previous version of PowerBI client.

On that note: Microsoft, please consider making a download archive easily available for older versions of Power BI Desktop. I keep my older installers when I upgrade, but it really should be possible to download at least the previous version from the download page. People experiencing this issue but who are without the older installer are essentially in a very difficult position... ;-)

Jesper Sommer's profile image Profile Picture

Andrey Metelskiy on 05 Jul 2020 22:33:26

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

The same is here.

Jesper Sommer's profile image Profile Picture

Alex Gorev on 05 Jul 2020 22:33:25

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

Thanks for reporting this issue Jesper! Can you share the report with me? My email is alexgor@microsoft.com.

Thanks,
Alex.