Power BI model refresh fails due to deleted or renamed columns in upstream.

[Jagruthi_Kesha]

Hi,

I'm encountering an issue where the Power BI scheduled refresh fails in the Service whenever columns are deleted or renamed in the upstream (Snowflake) source. I'm using Import mode to load the data, and my Power Query script is structured as follows:

let
Source = Snowflake.Databases(Snowflakeurl,"WH_XS"),
ABC_Database = Source{[Name="ABC",Kind="Database"]}[Data],
XYZ_Schema = ABC_Database{[Name="XYZ",Kind="Schema"]}[Data],
SALES_Table = XYZ_Schema{[Name="SALES",Kind="Table"]}[Data]
in
SALES_Table 

How can I handle schema changes gracefully - such as column deletions or renames - so that scheduled refreshes don't break in the Power BI Service?


Thanks for the help!

[Omid_Motamedise]

Hi @Jagruthi_Kesha 

You add a new step as following to handle it.

let
    Source = Snowflake.Databases(Snowflakeurl,"WH_XS"),
    ABC_Database = Source{[Name="ABC",Kind="Database"]}[Data],
    XYZ_Schema = ABC_Database{[Name="XYZ",Kind="Schema"]}[Data],
    SALES_Table = XYZ_Schema{[Name="SALES",Kind="Table"]}[Data],
    Untyped = Value.ReplaceType(SALES_Table, type table [ ])
in
    Untyped