Forum Discussion
sushovan93
Advocate I
9 months agoPower 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...
Ahmed-Elfeel
Super User
9 months agoHi 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
Advocate I
9 months agoI already have a ticket with MSFT. and we have workaround with other authentication