Snowflake: support GEOGRAPHY columns

[Anonymous]

Power BI Version: 2.91.884.0 64-bit (March 2021)

When I use the inbuilt Snowflake connector, I get an error when I connect to any table that contains a column of type GEOGRAPHY:

It can be worked around by using Snowflake views, but that's not ideal.

Could the connector be updated to ignore GEOGRAPHY columns? (other solutions welcome)

[v-yuaj-msft]

Hi @Anonymous ,

Based on your description, I think you could Edit the query in a Navigator window, which opens Query Editor so you can filter and refine the set of data you want to use, and then load that refined set of data into Power BI Desktop.

Hope that's what you were looking for.

Best Regards,

Yuna

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Won't work - the error occurs in the Query Editor as soon as the table is referenced. The Test_Table step in this example:

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],
  Test_Table = ADM_Schema{[Name=<Table Name>,Kind="Table"]}[Data]

in
  Test_Table

[v-yuaj-msft]

Hi @Anonymous ,

Thanks for your reply. Have you tried to use the ODBC connector to get data from snowflake?

Best Regards,

Yuna

[Anonymous]

Yes, same issue with the ODBC driver

[v-yuaj-msft]

Hi @Anonymous ,

Thanks for your reply. Do you install the Snowflake ODBC driver on computers that use the Snowflake connector, using the architecture that matches the installation of Power BI Desktop? 

Just follow the following link and download the appropriate Snowflake ODBC driver.

I find a similar documention. Please refer to it if it can help you a little.

ODBC Driver API Support — Snowflake Documentation

If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support to get further help.

Best Regards,

Yuna

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , there is blog around it, see if that can help

https://adatis.co.uk/displaying-vector-data-on-maps-in-power-bi/