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

[nishalit]

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.

[jesper_sommer]

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 🐵 )

[crue]

With version 2.40.4554.463 I can now open the reports that I was unable to before. So far so good on the issue I was experiencing.

[crue]

I am having what appears to be a related issue since the 10/31 update where it will not open previously working reports due to a circular dependency issue. Going back to a prior version of PBI desktop works for now, but really hoping that this is fixed soon.

[KStock]

This is serious. I have the same problem.

[fbcideas_migusr]

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

[fbcideas_migusr]

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]

'@Adam, the only solution currently is to revert to backup files, or if you have File History enabled, to go back to a file saved before upgrading the Power BI Desktop client. Then downgrade to the previous version, and continue working on that until a fix is offered.

[jesper_sommer]

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... 😉

[fbcideas_migusr]

As I presume this needs the attention of a different set of Dev/Support people, I've created a new Support issue for it: https://ideas.powerbi.com/forums/360879-issues/suggestions/16963468-unable-to-publish-or-upload-get-data-when-measure Please vote and comment to raise the priority of this issue.