Forum Discussion
File contains corrupted data
Hi
Previously, PowerBI Desktop was working very smoothly.
Today, when I stared the application, I got this message "File contains corrupted data". I googled for the reason and got that this is due to using customized chart. Indeed, Yesterday I was learning how to use custom map chart.
My problem is that I could not find a solution for this Issue; I tried to repair even reinstall the application but it did not work.
Your assistance is highly appreciated.
Hi azitony,
1. Please delete your desktop firstly.
2. Delete the Cache and CEF folders in the paths as below.
C:\Users\username\Microsoft\Power BI Desktop Store App
C:\Users\username\AppData\Local\Microsoft\Power BI Desktop
3. Reinstall your Power BI desktop and try again.
Regards,
Frank
20 Replies
Hi azitony,
1. Please delete your desktop firstly.
2. Delete the Cache and CEF folders in the paths as below.
C:\Users\username\Microsoft\Power BI Desktop Store App
C:\Users\username\AppData\Local\Microsoft\Power BI Desktop
3. Reinstall your Power BI desktop and try again.
Regards,
Frank
Hi v-frfei-msft,
When i upgraded the pbi desktop this month, this issue occured to me. I tried to delete the folders you mentioned and reinstalled pbi desktop, but it not work. What shall I do to fix it?
Best Regards,
I tired to reinstalled it in another path, the problem fixed. It seems some files cause this problem in the old folder.
Dear v-frfei-msft
Thank you for your reply.
The first folder "C:\Users\username\Microsoft\Power BI Desktop Store App" wasn't exicst on my PC.
I deleted the mentioned folders from the scond one and power BI worked.
But when I added shape map again and restarted the program, the Issue returned.
Best regards,
Hi azitony,
Could you find the paths then?
C:\Users\username\AppData\Local\Microsoft\Power BI
C:\Users\username\AppData\Local\Microsoft\Power BI Desktop
Then delete all the folders in the both paths and reinstall the Power BI desktop.
Regards,
Frank
Dear Anonymous
I changed the username to mine, and when I reinstalled the program, it worked fine.
The problem is once I activate shape map visual, PowerBI request for a restart to the program, after the restart, I receive the same error message.
Have I done anything wrong and can I do anything solve this issue.
Best regards,
The solution that you proposed is not working. We deleted the files and reinstall them but its still showing an error. We had to delete the model's tables and reconnect them to the origins. Our heavy files 05 databases are in Excel, saved in SharePoint and from this origin connected to Power BI, however they update without a problem from the web based Power BI, but from Power BI Desktop some update and some don't
Hi,
I had same problems with several excel files. I tried all mentioned steps from this topic, but without success. I have tried to remove workbook protection "Restrict access (Highly confidential)" in my case and now it works. I'm able to connect from Power BI to excel without error msg. Maybe this advice helps someone.
Peter
I also had the [File contains corrupted data] issue.
It seems PowerBI was not able to Get Data from an XL file with a password.
After removing said password, it works for me. In case this is useful to anyone 🙂
Hi
Have tried all the step by removing the password from the source excel file , removed 2 app/data files & reinstalled the desktop and still havin the same error message.
All my 6 source file are exactly the same format & formula but only 2 files that repressenting this year are having the error message . seems bit weired . did i done something wrong somewhere ? is there a way to fix this ?
Thanks
I had the same issue. In your source file go to File -> Info -> Check for Issues and click Inspect Document.
Leave default selections in the following screen and click “Inspect”
My specific issue was due to custom XML data but hopefully the tool will catch it if you have a different but similar issue.
When the error "File contains corrupted data. The exception was raised by the IDbCommand interface." appears in Power BI Online while refreshing data from Excel files, it is necessary to set the privacy level of each file to the highest level. In Spanish, this level is labeled "Reservada - Uso general" (Confidential - General Use).
