Forum Discussion
Error while connecting to snowflake through PowerBI Service.
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-credentials
Could you please assist me here please. or about the above article. I am stuck at this would be grateful for your assistance.
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
5 Replies
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
Have you find a solution for this issue? I am having the same one and the service account is configured and SSO as well.
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.
