power query remove empty columns

hi, Can anyone tell me if it is possible to "remove empty columns" as it is to "remove empty rows"? Thanks Juan

BI & Data Analysis

excel

SergeiBaklan

Apr 24, 2020

juan jimenez

If automatically that could be function like

(Source as table) as table =>

let
    RemoveEmptyColumns = Table.SelectColumns(
        Source,
        List.Select(
            Table.ColumnNames(Source),
            each List.NonNullCount(Table.Column(Source,_)) <> 0
        )
    )
in
    RemoveEmptyColumns

(Source as table) as table => let RemoveEmptyColumns = Table.SelectColumns( Source, List.Select( Table.ColumnNames(Source), each List.NonNullCount(Table.Column(Source,_)) <> 0 ) ) in RemoveEmptyColumns

Forum Discussion

power query remove empty columns

Resources