Forum Discussion
**HELP** USER-END -- Error: "Couldn't load the data for this visual"
Super UserDid your Power BI team enable Single Sign On (SSO) for the Snowflake data source across your capacity?
lbendlin thanks for the suggestion. Yes according to my powerbi team "Yes, snowflake is SSO"
Any other ideas?
Some recommended controlling factors -
1. What are your roles in SNOWFLAKE?When you're passing your credentials over to SNOWFLAKE, SNOWFLAKE should have certain roles assigned to you - Have you tested granting your SSO account a higher role access to match the PowerBI Team's?
If your team is unable to replicate the issue using their own SSO credentials in a similar use case, and you have the correct roles assigned, you may want to look at the default roles assigned to you, and see if changing that default to the role you're trying to utilize would help.
2. Can the issue be replicated with a SNOWFLAKE local account?In spite of having SNOWFLAKE SSO, I know Power BI can have some integration issues passing SSO credentials over to SNOWFLAKE. As an alternative troubleshooting strategy, are you able to test the data source using a test account created locally on SNOWFLAKE with the correct role? If that fails as well, then there may be something broken with end user permissioning.
Thinking about this for a bit - It sounds like the report you're using has several SNOWFLAKE connections, not just for this dashboard in the report - If that's the case, then you may want to have your team check to make sure that the FAMS_WH has the correct role access assigned.
