Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

File contains corrupted data Details: Binary

I created a PBIx using OneDrive - after a few hours, I started to receive the "File contains corrupted data Details: Binary" error. I managed to clear cache and delete CEF and that fixed it at first....
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

File is 33.3mb - I did try splitting this into 2 files yesterday and then was going to append but I had the same issue.

 

I have just cut the file down to 20,000 rows and it refreshed. Does that mean there's an error in the other however many rows or?

 

Do we know why it would randomly bring up the error though even though I have worked on it for several hours today with no problems? It was only when I added a conditional column that it appeared to cause an error.

edhans's avatar
edhans
Community Champion
6 years ago

I would be inclined to open a support ticket with MS at the bottom of the Power BI support page. I cannot do that as the file I was having an issue with I got rid of and we moved to a direct SQL access, but it seems clear that there is a glitch in Power BI Desktop with larger Excel files on Sharepoint that started probably with the April desktop update.