Snowflake - Geography column causes connection error
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
3 Comments
- v-chuncz-msftCommunity Support
Anonymous
You may try to specify SQL statement in the Advanced option.
- mknoppNew Member
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.
- AnonymousNot applicable
Snowflake have fixed this v2.23.2 of their ODBC driver. Now we just need the inbuilt PowerBI connector to pick this up.