Issue with Power BI service for SSO in snowflake

[Anonymous]

Hi Team,

I am able to connect Power BI desktop with snowflake using microsoft account however when I am trying to use SSO in power bi service using Oauth2, it is getting failed and showing some error. Could you please help on this.

Error detail - Failed to update data source credentials: The credentials provided for the Snowflake source are invalid. (Source at ma73496.us-east-

Regards,

Azad

[Anonymous · Accepted solution]

Hi @Anonymous ,

Though the error message on the PowerBI (PBI) UI mentions invalid credentials, the root cause of the issue is that the user logging in does not have the DEFAULT_ROLE set for it or the role name set does not have privileges/access to the Warehouse which is being set for use from PowerBI. 

Following are the points which need to be checked for this scenario: 

1. Check the user and verify if DEFAULT_ROLE is set for it. If it is not set, then run the following SQL query and make sure that the role is granted to the user:

alter user <username> set default_role=<rolename>; 

2. Check the Warehouse which is being used for the connection part and verify if the role assigned to the user has access to it. To verify this, run the following SQL:

show grants ON warehouse <WH Name>;

From the results here, check to see if the role assigned to the user has USAGE access to the Warehouse. 

For more details, you could read related document:

Power BI SSO to Snowflake | Snowflake Documentation,

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

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.