PBI Desktop Error: "We weren't able to restore the saved database to the model"

[PJW_TMD]

Hi,

I have recently upgraded to the May version of PBI Desktop (2.46.4732.581 64-bit). 

My .pbix file is created in DirectQuery mode, its datasource is an MS SQL database.

My file was created in a previous version (perhaps March or April), it opened fine in the May version, however after saving in the May version I am now unable to re-open the file, receiving the error "We weren't able to restore the saved database to the model".

I have researched the issue and the solution seems to be to uninstall and re-install a previous version. However - 1. I cannot locate a previous version, and 2. I have saved the file in the May version so I have doubts a previous version would see the file as compatible.

Has anyone encountered this issue with the May release and are aware of a solution? Or am I going to have to rebuild my entire report file? This seems to be a reoccurring issue with PBI updates - and causes hours upon hours of work to be lost!

Thanks

[amyjefferson]

Hi

Did anyone find a solution to this? I am also facing the same problem. I am on the latest version of Power Bi and I have tried to download the pbix file from the service but still have the issue.

Thanks!

Amy

[musicbydannyd]

Solved by updating to latest version: https://community.powerbi.com/t5/Desktop/Unable-to-open-document-we-weren-t-able-to-restore-saved/m-...

[v-jiascu-msft]

@PJW_TMD

Hi,

The newest version of PBI Desktop is  2.46.4732.721 64-bit (May 2017). Please upgrade to the newest version.

Maybe there is another way you can try. But I am not sure if it will work.  

1. In PBI service, upload the PBIX with “Get Data”;
2. Download the file with “Download .PBIX”.

 

Best Regards!

Dale

[gopichilla]

Hi @PJW_TMD

I have checked in my system it is working fine.

Can you uninstall your desktop version and reinstall then check.

Thanks

[PJW_TMD]

Hi @gopichilla,

I have just tried your suggestion but still receive the same error.

Thanks