DataFormat Error: File Contains corrupted data / Details: [Binary]

[Chipsnump]

Hi All, 

Please suggest how to avoid this such error.

It would happen many times when the corporate connection got slowness or unstable. Apart of hanadle with the connection, is there any solution to do with the file or prepation process?

File: Excel

Souce: Sharepoint

[Anonymous]

Hi @Chipsnump 

The following steps are for your reference:

• Ensure that the Excel file you want to connect to is in a format supported by Power Query. Power Query works best with .xlsx files. If your file is in a different format (e.g. .xls), consider saving it in .xlsx format before attempting to connect.

• Sometimes, special characters in file names or SharePoint location paths can cause problems. Make sure there are no special characters or spaces in the file name or path. You can refer to the following post: DataFormat.Error: File contains corrupted data. Details: [Binary] - Microsoft Community

• You can also try restarting your Power BI desktop, clearing temporary files.

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Chipsnump]

@Anonymous  thank you for your sharing.

I'm afraid that I am following your instruction all, this is my file:

- Name: "00.Sales_CurrentYear.xlsx