I seem to be getting regular problems with my PBI in terms that i keep getting the message "Unable to open document", "(file location) is corrupt or invalid report file"
I am trying to track back what has caused this, literally at the start of the week the i installed the November 2017 update for PBI which it seems i only seem to be getting the problems since then, other than that, i have had to force close PBI and other programmes on my pc because of screen freeze issues, does force close of Power BI cause its main location file to be corrupt or invalid?
Or any other issues that are common with PBI that may cause this? and a possible solution?
open the online version of the report in browser, download as a .pbix file and replace the desktop corrupted report with this new report downloaded from browser. worked for me 😉
Good Morning All,
I spent an hour this morning trying to figure how to resolve this issue. Option A (below) did not work for me because I accidently deleted the recovery file.
Option A: (most common resolution)
I had the same problem ,producing when i copy a file from the server to my local machine,what i did is updating power bi in the server and in my local machine,after that i created a new saved file and copied to my machine and it worked
In my test, all previous pbix files work fine after I update desktop to the latest version (November 2017). In your scenario, does this issue happen to all your previous pbix files or just a specific one?
Rather than directly double clicking .pbix file, open Power BI Desktop, click File -> Open -> Select the corrupted pbix file. If you can see a yellow ribbon saying “open in autorecovery mode..” Click on it and the file will be opened with the version before it got corrupted.
If you still cannot open it, please copy your .pbix file under a different file path, then, try to open it.
Besides, please try smoupre's suggestion here to see whether it works for you.
You siad "i have had to force close PBI and other programmes on my pc because of screen freeze issues" since update, please uninstall and re-install the latest release for a test.
Thanks for your reply, i have managed to go back in time and restore the file to a previous version before it went corrupt, that seemed to work however i believe this might be a re-ocurring issue as its already happened twice this week. If it happens again i will definately try both your possible solutions and thankyou for the replies
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.