Loading...

The Power Query XML Functions, Missing Or Null Values And Inconsistent Schema Inference

The Power Query XML Functions, Missing Or Null Values And Inconsistent Schema Inference
A few months ago one of my colleagues at Microsoft, David Browne, showed me an interesting Power Query problem with how the Xml.Tables and Xml.Document M functions handle null or missing values. I’m posting the details here because the problem seems fairly common, it causes a lot of confusion and it’s not easy to deal […]

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

New Performance Optimisation for Excel PivotTables Connected To Power BI Semantic Models

Some good news: an important optimisation has rolled out for Excel PivotTables connected to Power BI semantic models! Back in 2019 I wrote abo...

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