Loading...

Understanding The “External table is not in the expected format” Error In Power Query In Power BI And Excel

Understanding The “External table is not in the expected format” Error In Power Query In Power BI And Excel
Solve the "Extenal table is not in the expected format" error by making sure you're importing data from files of the correct type

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

Optimising DAX: The Formula Engine and Storage Engine

When you execute a DAX query, two engines divide up the work. Understanding the split between the formula engine and the storage engine is key...

13 hours ago

How Microsoft Fabric, Azure, and Power BI Are Transforming Analytics

Introduction Data has become one of the most valuable assets for modern organisations. However, collecting data alone is no longer enough—busi...

3 days ago

Agentic AI in Power BI and Fabric, Part 4: From Skills to an Agentic Report Theme Audit Workflow

In Part 1, I went through the concepts and terminology behind agentic AI, things like agents, tools, skills, MCP, guardrails, and Human i...

3 days ago

Analysing Power BI Data Using Copilot In Excel

This week there was another big Copilot-related announcement for Power BI – but on the Excel blog. You can now analyse data from Power B...

4 days ago

Power BI, M365 Copilot And The Importance Of DAX UDFs

This was a big week for Power BI Copilot with the announcement of a new direction for the feature. If you haven’t done so already, read ...

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