Same error different files file contains corrupted data, value -2147467259

Hi DouweMeer ,

Thank you for reaching out to the Microsoft Community Forum.

Hi GilbertQ , Thank you for your prompt response.

Hi DouweMeer , As you mentioned that, You are facing error “File contains corrupted data” with value -2147467259, which appears across different files during refreshes via the Gateway, but not when refreshing in Power BI Desktop.

The error code "-2147467259" corresponds to a generic COM error often triggered by data format issues or corruption in the source file. The message DM_GWPipeline_Gateway_MashupDataAccessError indicates that the Power BI Gateway is failing to access the data correctly.

Please try below steps to fix the issue.

1. You mentioned manually copyed data into a new Excel file works. Automate this by opening the file in Excel and Save it as .xlsx file. Also check no hidden sheets or broken links exist.

2. In Power BI, Go to Transform Data and apply Clean, Trim, and Replace Errors operations on all columns and Remove blank rows and columns.

3. Clear Power BI Cache, Go to File --> Options and Settings --> Options --> Data Load and Click Clear Cache.

4. Check the Gateway is updated and Verify that the file path is accessible and not on a network drive and Use Import Mode instead of DirectQuery if possible.

Please refer Microsoft official document and community threads.

Dealing with errors - Power Query | Microsoft Learn

Solved: File contains corrupted data - Microsoft Fabric Community

Solved: Re: DM_GWPipeline_Gateway_MashupDataAccessError - Microsoft Fabric Community

Solved: DM_GWPipeline_Gateway_MashupDataAccessError - Microsoft Fabric Community

Solved: DM_GWPipeline_Gateway_MashupDataAccessError (Not l... - Microsoft Fabric Community

If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.

Regards,

Dinesh