PBIX file corrupted

[willnic]

I worked on a model last week where I added some calculations. Now when I try to open it up I get the error message saying "Unable to Open Document" with the file past listed, saying it is "corrupt or not a valid report file."

The only changes I made to the file were calculations and everything was working. I can even see that it saved properly based on the timestamp on the file.

I really don't want to have to rebuild this model -- any way I can save this?

[ckodadek]

This just happened to me at a very inconvenient time when dealing with measures...
Any updates on how to uncorrupt?

[KathyPullin]

Any update or fixes available on this issue?

[willnic]

I should also note that I logged a ticket and they have been investigating my file but can't find a solution to resurrect it. I ended up having to rebuild.

[Greg_Deckler]

You can try copying it and changing the file extension to ".zip" and you might be able to salvage something. I've only run into file corruption once when switching back and forth between Excel 2016 and Excel 2013. Spent quite a bit of time rebuilding that one...

[willnic]

Thanks for the idea -- tried that with no luck, I still get the same error message unfortunately.

[Greg_Deckler]

I guess I should have probably elaborated on the idea a little. The thought was that you could copy the first file to a zip file. Create another new PBIX file, rename that to a zip. Go into the first zip and copy out certain files like "Data Model" and paste into your new zip folder, rename the zip to pbix and see if you can open it.

Long shot, but might work.

[willnic]

Thanks for clarifying. I tried your solution, but it appears that the corrupt PBIX file (the first zip file I created) does not have the underlying files in it. When I zip the folder and try to access, it says "Windows cannot open the folder" then has the file name saying it is "invalid." I tried this with my other PBIX files that are working fine, and when I do the same procedure and open the zip file, I see a Report subfolder, along with the files like DataMashup, DataModel, DiagramState,Metadata, etc. I am wondering if this is part of the problem? 

The weird thing is the PBIX file shows that it is 30 MB so clearly the data is there -- but it's like the file lost its underlying components?

[Greg_Deckler]

Seems like it is truly corrupted at the file structural level. So, all of the data is there but something in the structure of the file has become corrupted such that it essentially is no longer a valid "zip" file. So when trying to view it via native zip tools, it is not really a valid file. Wonder if it happened during file compression, something went haywire.

Sorry man, you're probably out of luck unless you can find some sort of "zip repair" tool that will work on it. There are some available, Bing "zip repair tool" and you will get hits from CNET and PC World.

[willnic]

Got it -- thanks so much for your advice!

[annwallinger]

The same thing just happened with my team. We added a calculation, saved and closed the file and then were no longer able to use it as it says it is corrupt. This appears to be a bug.