Forum Discussion

sushovan93's avatar
sushovan93
Icon for Advocate I rankAdvocate I
9 months ago

Power BI desktop bug for Snowflake key Pair authentication

in Power BI even though we use the implementation=1.0 that supposed to execute the Query with ODBC driver we have seen when we use Key-pair authentication it by default execute the query as ADBC driv...
General Comment
Show and Tell
sushovan93's avatar
sushovan93
Icon for Advocate I rankAdvocate I
9 months ago

I'm already trying that, and it does work for other autentication methods, Oauth and Snowflake authentication does recognize the connector changes I can easily make it to ADBC with implementation=2.0 and ODBC using implementation=1.0, only problem with the Key-Pair authentication it does not change the driver if we use the implementation = 1.0 still uses the ADBC driver.

And in that the new ADBC driver has memory issue with large data that is alrady  a known issue.

Ahmed-Elfeel's avatar
Ahmed-Elfeel
Icon for Super User rankSuper User
9 months ago

Hi sushovan93,

The only way i see to bypass this (until this issue solve) is to

  • set up a System DSN on your machine using the Snowflake ODBC driver 
  • In Power BI Desktop use the ODBC connector (not the Snowflake connector) and select your DSN
  • This method will give you full control over the driver and has been a stable workaround for many

Also Try to raise a ticket for Microsoft Support Team

if this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly
  • sushovan93's avatar
    sushovan93
    Icon for Advocate I rankAdvocate I
    9 months ago

    I already have a ticket with MSFT. and we have workaround with other authentication