Anonymous's avatar
Anonymous
Not applicable
5 years ago
Status:
New

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-msft's avatar
    v-chuncz-msft
    Community Support

    Anonymous 

     

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

  • 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's avatar
    Anonymous
    Not applicable

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