Forum Discussion
File contains corrupted data Details: Binary
I cannot tell from your post if the PBIX is corrupt, or the XLSX. If it is XLSX, that is probably not the issue. I had a similar error this week and opening/saving/closing the Excel file fixed it. it was an intermittent issue.
But storing files on one drive, your c drive, or sharepoint and then moving them should not cause anything in your model to be deleted. You would have to recreate the Power Query link and edit the M code as a C drive, OneDrive, and Sharepoint connection are all a bit different, but that is just the first 2-4 steps until you read the binary .xlsx file in. (Binary in the sense that XLSX is a ZIP file and Power BI has to crack it open, not binary in that any of your data is 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 😣
The xlsx file is not corrupt - I can open this fine in Excel. It's in Power BI - so I can open the file in Power BI but I cannot apply changes or refresh as I receive the below error -
DataFormat.Error: File contains corrupted data.
Details:
[Binary]