Forum Discussion

rovamaq's avatar
rovamaq
Frequent Visitor
9 years ago

CORRUPT PBIX FILE

Hi, I just saved 2 PBIX files, my PC restarts and now i can't open any of these files. When i try to open it a message is displayed saying that the file is corrupted. I tried to restore previous ver...
Dashboards
Reports
GilbertQ's avatar
GilbertQ
Super User
9 years ago

There might be a way to do this, depending on where the corruption is.

 

If it is in the Data Model you might be able to get all the Query Editor steps, and then have to rebuild the data model. That you can do by renaming it as a ZIP file and then copying the DataMashup out into a folder.

 

Then create a new Power BI Desktop File and save it, and close it down.

Rename this file to a ZIP and copy the DataMashup from above into this ZIP file. 

Once that is done rename it back to PBIX and see if you can now view all the information in your Query Editor.

 

If you want to do this for all your measures you can do it but this time you must do the same steps but do it for the DataModel & Metadata files.

  • mwadhwani's avatar
    mwadhwani
    Kudo Kingpin
    8 years ago

    Hi GilbertQ

     

    But data model file is in unreadable form. How I can achieve this for measures then???

      • mwadhwani's avatar
        mwadhwani
        Kudo Kingpin
        8 years ago

        Thanks GilbertQ for the reply. 

        But when I create any report and send that .pbix to .zip and then going to Data Model file its always in unreadable form. 
         I read blog in which it says Data Model stores actual data. Also in the Metadata folder I can just interpret name of the tables and some numbers assigned to it. I am not sure whether that number is in hex format or not. What is the significance of that number.

        Also If I want to read Data model file what I need to follow. Can you please suggest me..!!

         

        Thanks