Skip to main content

    Power BI

    Needs Votes

    Fix Power Query Glitch for Loaded Tables

    Vote (13) Share
    Wyn Hopkins's profile image

    Wyn Hopkins on 20 Apr 2016 17:18:51

    When loading Power Query as a table into Excel you can add formula to adjacent columns and they will copy down automatically. However when refreshed the formula does not copy down correctly unless you change Table Properties to Preserve Column Sort / Filter Layout

    https://www.linkedin.com/pulse/dont-get-caught-power-query-trap-wyn-hopkins

    Comments (2)
    Wyn Hopkins's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:28:30

    RE: Fix Power Query Glitch for Loaded Tables

    Common sense fix. You've got my support Wyn

    Wyn Hopkins's profile image Profile Picture

    Wyn Hopkins on 05 Jul 2020 22:28:27

    RE: Fix Power Query Glitch for Loaded Tables

    Appears to be fixed in Latest Excel 2016 version