File contains Corrupted data error in Excel power query

[Dineez18]

Hi,

I'm trying to connect 2 sharepoint excel files through Power Query > Data > Get & Transform data > From Web

But it is throwing error as below

I've tried restarting desktop and clearign %temp% & temp, in excel info > Check for issues and even created two dummy excel with no data and tried connected inbetween them. nothing seems to be working.

Also gone through below suggestions, no improvements.
https://community.fabric.microsoft.com/t5/Service/Sharepoint-Excel-file-refreshes-in-Desktop-errors-...

https://learn.microsoft.com/en-us/power-query/connectors/excel#file-contains-corrupted-data-errors


Can anyone help me coming out of this?

I'm doing this for Power Automate flow for connecting excels to get the data reflected from output.

[tharunkumarRTK]

@Dineez18 
Have you tried changing the sensitivity label of the excel file? keep it at the lowest level possible and check. 
Generally confidential protected sensitivity labels causes this kind of issues.

[v-stephen-msft · Accepted solution]

Hi @Dineez18 ,

The "File contains corrupted data" error can indeed be frustrating, but let's work through some steps to potentially resolve this.

Given the steps you've already tried, including restarting, clearing temp files, and checking for issues within Excel, it seems you've covered some common troubleshooting ground. The error you're experiencing typically points to issues with the file format or compatibility between the file and the Power Query connector.

Action Plan:

1. Verify File Format and Compatibility: Ensure that the Excel files you're trying to connect to are in a format supported by Power Query. Power Query works best with .xlsx files. If your files are in another format (e.g., .xls), consider saving them as .xlsx and then try connecting again.

2. Check for Special Characters in File Names or Paths: Sometimes, special characters in the file name or the path to the SharePoint location can cause issues. Ensure there are no special characters or spaces in the file names or paths. Similar post: DataFormat.Error: File contains corrupted data. Details: [Binary] - Microsoft Community

3. Match Power BI Desktop and Microsoft Office Versions: If you're using Power BI Desktop, ensure that its bit version (32-bit or 64-bit) matches the bit version of Microsoft Office installed on your computer. Mismatched versions can lead to connectivity issues.

Best Regards,

Stephen Tao

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

[Dineez18]

Have tried through that alternative as well, throws same error! 😞

[lbendlin]

Use the SharePoint Folders connector.