Power bi unable to load adbc driver for a connection to snowflake

[imtiazg12345]

Hi,

I am trying to import data from a snowflake warehouse. However, I am unable to establish a connection with the server and database. I receive the following error message:

The credentials I am trying have access to the Snowflake warehouse and are able to make a connection when using Tableau. My power bi desktop is running the most recent version from the MSFT store. Any help would be much appreciated. 

Kind regards,

[v-nmadadi-msft]

Hi @imtiazg12345 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[imtiazg12345]

Hi @v-nmadadi-msft ,

Thank you for your response. This indeed solved the ADBC driver problem. However, unfortunately we were still not able to connect due to the security integration not being set in Snowflake when loging in with an entra account. 

Error when connecting Power BI Desktop via SSO to Snowflake: "We couldn't authenticate with the cred...

[v-nmadadi-msft]

Hi @imtiazg12345 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-nmadadi-msft · Accepted solution]

Hi @imtiazg12345  ,
Thanks for reaching out to the Microsoft fabric community forum.

Navigate to Options and settings (under the File tab) > Options > Preview features, and then select the checkbox to disable the Use new Snowflake connector implementation option.

or remove the Implementation="2.0" flag from existing queries.

Recheck after doing that step the status of your connection.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thank you

[pankajnamekar25]

Hello @imtiazg12345 

The error you're seeing is due to an invalid OAuth access token. To resolve this, sign out of Power BI, restart it, and re-authenticate your Snowflake connection ensure you're selecting the correct authentication method (OAuth) and granting necessary permissions. If the issue persists, clear cached credentials in Power BI under File > Options and settings > Data source settings, then reconnect.

Thanks

 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[imtiazg12345]

Thank you for your response. I tried that and used 2 different devices with Power bi desktop installed. I managed to create a connection using the ODBC-connector with the Snowflake server using the following guide https://community.snowflake.com/s/article/How-to-connect-Power-BI-Desktop-to-Snowflake-using-OKTA-SS...

However, now when I publish the report the connection is classified as an on-premise connection which I can't seem to replace with the snowflake connection through connections & gateways setting in Power Bi service. 

[speedramps]

This may help ...

https://community.fabric.microsoft.com/t5/Desktop/Snowflake-ODBC-Error-Invalid-OAuth-Token/td-p/1275...