Skip to main content

Power BI

New

Change IntelliSense Handling of "null" in Power Query from "Null.Type" to "null"

Vote (6) Share
Joshua Hammond's profile image

Joshua Hammond on 26 Sep 2021 01:22:29

When writing code in Power Query that includes null values, IntelliSense recommends "Null.Type". If you're writing out conditional statements, such as "if [A] > [B] then null", IntelliSense will insert ".Type" at the end of your expression when you hit space or enter/return. This can cause a lot of confusion for newer users and frustration for more advanced users. It is also incredibly difficult to find documentation on "Null.Type" in Power Query.
The default handling of null should be null.