cancel
Showing results for 
Search instead for 
Did you mean: 

Snowflake - Geography column causes connection error

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

andban_0-1618490665606.png

 

  • 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

Status: New
Comments
v-chuncz-msft
Community Support

@andban 

 

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