Forum Discussion
File contains corrupted data Details: Binary
Hi,
Thanks for your reply - my concern isn't that the measures were deleted as I put those back really quickly. My issue is that I am now having the below error for a second time -
DataFormat.Error: File contains corrupted data.
Details:
[Binary]
When I click on go error - it takes me to the source and shows me "sheet1" and "table1" but doesn't give me any idea of where the error lies. The file is an xlsx file - there is one column that could be perceived as a binary as it always a 1 but is imported as a number so i'm not sure that that is the issue.
What happens if you do this?
- refresh the data (not refresh preview, but all of it)
- Open, save, and close the excel file, then refresh again?
It has nothing to do with that 1. a binary error is not an error in data that is binary (0 or 1) but in the file itself, which is considered a binary data source.
Refreshing I get the "File contains corrupted data" error.
I have tried opening, saving, closing but it doesn't seem to make any difference 😣
I am pretty sure the error is with your Excel file, not your PBIX.
Test this:
- Save the Excel file.
- Close the Excel file.
- Make a copy of it.
- Open the original Excel file.
- Delete 99% of the data so it is really small.
- Save and close the file
- REfresh the PBIX.
What happens then? And as an aside, how big is this file?
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.