Snowflake - Geography column causes connection error

[Anonymous]

An assertion failure is generated if I connect to a table with a Geography column:

• This occurs with both the inbuilt Snowflake connector & the ODBC driver.
• It cannot be worked around within Power BI: the error occurs as soon as the table is referenced, so there is no opportunity to delete/skip the column. 

Test expression:

let

Source = Snowflake.Databases(<URL>, <Warehouse>, [CreateNavigationProperties=null,   ConnectionTimeout=null, CommandTimeout=null]),
Test_Database = Source{[Name=<Database>,Kind="Database"]}[Data],
Schema = Test_Database{[Name=<Schema Name>,Kind="Schema"]}[Data],

// Error occurs on the line below
Test_Table = ADM_Schema{[Name=<Table With Geography Column>,Kind="Table"]}[Data]

in

Test_Table

[v-chuncz-msft]

@Anonymous 

You may try to specify SQL statement in the Advanced option.

[mknopp]

Issue is still present in the June 2021 release. Important for Energy/Resource based customers to be able to work with Geography columns easily in PowerBI. Not having the same issue when using tools like Spotfire. 

[Anonymous]

Snowflake have fixed this v2.23.2 of their ODBC driver. Now we just need the inbuilt PowerBI connector to pick this up.