Forum Discussion
Snowflake credentials is not working in Power BI Desktop
Although Snowflake access is available, the same credentials are not working in Power BI Desktop. Please see the error message below.
Can anyone help me resolve this issue.
3 Replies
- Ritaf1983
Super User
There could be several reasons for authentication issues with Snowflake. One common cause is using the wrong username. Snowflake typically requires a username to log in, not an email address. Here's how you can troubleshoot and resolve the issue:
Steps to Troubleshoot and Resolve:
-
Verify Your Username:
- Log in to your Snowflake account using a web browser.
- Navigate to your Profile or Settings section to find the username assigned to your account.
- Ensure you use this username, not your email address, when connecting through Power BI.
-
Check with Your Snowflake Admin:
- If you're unsure about your username or don’t have access to your account settings, contact your organization's Snowflake administrator. They can confirm your username and ensure your account has the necessary permissions.
-
Test Both Username and Email:
- Try logging in with your username instead of your email address in Power BI.
- If neither works, this can help identify if the issue lies elsewhere.
-
Review Authentication Method:
- Ensure that the authentication method in Power BI matches what is configured for your Snowflake account (e.g., Username/Password or SSO).
- If your organization uses SSO or OAuth, confirm with your admin if additional steps are required.
-
Reset the Connection in Power BI:
- Go to Data Source Settings in Power BI Desktop.
- Clear the credentials for your Snowflake connection and reconnect using the verified username.
If the problem persists, it’s recommended to reach out to Snowflake’s technical support or Power BI’s support team for further assistance. They can help identify and resolve any specific issues related to your setup.Link to opening support ticket :
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
-
- shashidharFrequent Visitor
Could you ask the Snowflake admin to add your email which you are using for power bi, so you can able to access to the database from here.
IF THIS HELPS YOU PLEASE MARK THIS AS A SOLUTION. - AnonymousNot applicable
I found some solutions for the same problem on the Snowflake Community, you can try them out. It seems that you need to make some changes to the account or permissions in Snowflake. I hope the following links would be helpful.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!