Skip to main content

    Power BI

    New

    Query error handling if exists

    Vote (1) Share
    Daniel Bartley's profile image

    Daniel Bartley on 18 Aug 2017 10:20:15

    I have a fleet of files connected to sql databases.
    If we had redundant columns in the source we sometimes removed them using the power query "remove columns" feature.

    The gotcha is that if you later remove the columns from the source system, the query breaks because it cant find the columns to remove them.

    Syntax similar to the 'DROP column IF EXISTS' would be more resilient and easy to understand.

    Comments (1)
    Daniel Bartley's profile image Profile Picture

    1a95fcf7 aa43-482a-99dc-5e8472dc4bea on 05 Jul 2020 23:03:41

    RE: Query error handling if exists

    select the columns you want to keep, then use the 'remove other columns' button.