Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Dineez18
Employee
Employee

File contains Corrupted data error in Excel power query

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

Dineez18_0-1707464725290.png

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.

1 ACCEPTED SOLUTION
v-stephen-msft
Community Support
Community Support

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.           

View solution in original post

4 REPLIES 4
tharunkumarRTK
Solution Sage
Solution Sage

@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
Community Support
Community Support

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
Employee
Employee

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

lbendlin
Super User
Super User

Use the SharePoint Folders connector.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors