Issue Connecting Snowflake to Power BI Service using Basic Authentication

Hi vamshikrishna20 , Thank you for reaching out to the Microsoft Community Forum.

Power BI Desktop and Power BI Service handle credentials differently. In Desktop, the connection is established interactively and the Snowflake connector simply sends whatever you provide in the password field to Snowflake. So, if you paste a JWT token instead of a password, it can work for that session as long as the token is valid.

In Power BI Service, the dataset credentials must be stored and reused by the service. The Snowflake connector there expects a supported credential format (such as username and password or OAuth). A JWT token pasted into the password field is not a supported stored credential and is typically short-lived, so the Service cannot reuse it to authenticate the dataset.

To get this working in the Service, you’ll need to configure the dataset with a supported authentication method, usually a Snowflake username and password or OAuth/Entra ID if your Snowflake environment is configured for it. This allows the Service to securely store and reuse the credentials for queries.

Connect to Snowflake with Power BI - Power BI | Microsoft Learn

Snowflake MFA Key - Pair authentication for Powerbi - Microsoft Q&A

Key-pair authentication and key-pair rotation | Snowflake Documentation

Partner support for Snowflake authentication methods | Snowflake Documentation