Loading...

The “DataFormat.Error: File contains corrupted data” Error In Power Query

The “DataFormat.Error: File contains corrupted data” Error In Power Query
When you’re using Excel workbooks as a data source in Power Query in either Excel or Power BI you may encounter the following error when trying to connect: DataFormat.Error: File contains corrupted data. There are three possible causes of this error that I know of, two of which are well documented. First, the file may … Continue reading The “DataFormat.Error: File contains corrupted data” Error In Power Query

Published on:

Learn more
Chris Webb's BI Blog Chris Webb's BI Blog
Chris Webb's BI Blog Chris Webb's BI Blog

A blog about Power BI, SQL Server Analysis Services (Multidimensional and Tabular), MDX, DAX, Power Pivot, Power Query, M, Power Map and Excel for BI

Share post:

Related posts

Filter data with single date slicer when multiple dates in fact table fall in range without creating relationship in Power BI

Hi Folks, After a while, I am back with another interesting way to solve this type of problem in Power BI. It took increasingly more amount of...

3 hours ago

Finding the Date of the Next Record in Power Query

Today I’m going to share my solution to a question I found on the MrExcel forum. It’s an interesting problem. https://www.mrexcel.com/bo...

13 hours ago

Why Power BI Table Visuals With Scrollbars Can Cause Problems

Concluding my series of blog posts on seemingly harmless things you can do in a Power BI report that can lead to performance problems and the ...

21 hours ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy