Reply
Frequent Visitor
Posts: 7
Registered: ‎10-06-2016

After latest update getting error publishing, and now can't open pbix file

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.

Frequent Visitor
Posts: 2
Registered: ‎11-01-2016

Re: After latest update getting error publishing, and now can't open pbix file

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.

Highlighted
Super User
Posts: 3,458
Registered: ‎06-25-2015

Re: After latest update getting error publishing, and now can't open pbix file

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

Near SE WI? Join our PUG MSBIWI
Visitor
Posts: 2
Registered: ‎11-02-2016

Re: After latest update getting error publishing, and now can't open pbix file

I am experiencing this error on some PBIX files. Can you send teh link where I can download an earlier version.

 

Thanks

  Iain

Super User
Posts: 3,458
Registered: ‎06-25-2015

Re: After latest update getting error publishing, and now can't open pbix file

@Dryburghi You can find the previous versions and the most recent October versions here The September release is (29), but you can determine that by the download dates as to which month you want.

Near SE WI? Join our PUG MSBIWI
Frequent Visitor
Posts: 7
Registered: ‎10-06-2016

Re: After latest update getting error publishing, and now can't open pbix file

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. Smiley Mad

Advisor
Posts: 280
Registered: ‎06-28-2015

Re: After latest update getting error publishing, and now can't open pbix file

These issues appear to be related:

 

http://community.powerbi.com/t5/Desktop/After-upgrading-to-Oct-30-2016-I-cannot-refresh-my-model-any...

 

https://ideas.powerbi.com/forums/360879-issues/suggestions/16893475-unable-to-open-document-we-weren...

 

 

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. 

Moderator
Posts: 9,540
Registered: ‎03-10-2016

Re: After latest update getting error publishing, and now can't open pbix file

Hi @DBDave,

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.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor
Posts: 7
Registered: ‎10-06-2016

Re: After latest update getting error publishing, and now can't open pbix file

Hi. I don't get the option to send a frown. It errors straight away when i try to open the file.

 

Capture.PNG

 

My issue is not related to RLS at all, and is not the same scenario that this post refers to.  However, this issue describes exactly what I've experienced. 

 

Advisor
Posts: 280
Registered: ‎06-28-2015

Re: After latest update getting error publishing, and now can't open pbix file

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.