Error while connecting to snowflake through PowerBI Service.

[Rohit17]

occuring the error while trying to schedule refresh for one of my report through power bi service. the source is snowflake. 
When I tried to edit credentials I am getting below error - 

Failed to update data source credentials: The credentials provided for the Snowflake source are invalid.

however with the same credentials power bi desktop is connecting smoothly with snowflake. 

I have got one article here. it says that it is due to network policy (unsure if this will fix my issue) - https://community.snowflake.com/s/article/Power-BI-Service-authentication-error-with-working-credent...

Could you please assist me here please. or about the above article. I am stuck at this would be grateful for your assistance. 

[Alli2024]

Have you find a solution for this issue? I am having the same one and the service account is configured and SSO as well.

[Rohit17]

Hello - the issue is resolved when I changed public role to Snowflake role for that connection in snowflake. It was CDP PROD ANALYST role in my caee. 

[aj1973]

Hi @Rohit17 

When you click on edit credentials how do you connect?

[Rohit17]

hi @aj1973 ,
Thanks for responding.

I have tried Oauth2 and basic with organizational, public and private level setting. 
the result is same . 

[aj1973 · Accepted solution]

2 things to consider: 

• See with snowflake admin if they set up a  service account to connect to snowflake DWH in the cloud
• See with Power BI Admin if SSO for snowflake connection is enabled

https://learn.microsoft.com/en-us/power-bi/connect-data/service-connect-snowflake