Forum Discussion
Lorenzo
Apr 08, 2024Silver Contributor
Power Query Table.Profile: The field 'NullCount' of the record wasn't found
With Microsoft Excel for Microsoft 365 MSO (Version 2403 Build 16.0.17425.20124) 64-bit and Power BI Desktop Version: 2.127.1327.0 64-bit let
Source = Table.FromColumns({{1..3}, {"a"}},
...
- Apr 08, 2024
It works as
let Source = Table.FromColumns({{1..3}, {"a"}}, type table [A=Int64.Type, B=Text.Type] ), Profiled = Table.Profile(Source), Issue = Table.SelectRows(Profiled, each [NullCount] = 0), // ==> Expression.Error: The field 'NullCount' of the record wasn't found WokrsAs = Table.SelectRows( Table.StopFolding( Profiled ), each ([NullCount] = 0) ) in WokrsAs
SergeiBaklan
MVP
It works as
let
Source = Table.FromColumns({{1..3}, {"a"}},
type table [A=Int64.Type, B=Text.Type]
),
Profiled = Table.Profile(Source),
Issue = Table.SelectRows(Profiled, each [NullCount] = 0),
// ==> Expression.Error: The field 'NullCount' of the record wasn't found
WokrsAs = Table.SelectRows( Table.StopFolding( Profiled ), each ([NullCount] = 0)
)
in
WokrsAs
Lorenzo
Apr 10, 2024Silver Contributor
Table.StopFolding seems to have been intro. somewhere in May 2022:
- https://blog.crossjoin.co.uk/2022/05/16/im-posting-on-the-power-query-blog-too/
- https://community.fabric.microsoft.com/t5/Power-Query/Availability-of-Table-StopFolding/m-p/3080664
so it's probably not avail. in Excel 2016...2021 versions