**HELP** USER-END -- Error: "Couldn't load the data for this visual"

[Anonymous]

Hey Guys,

So I'm the "USER END" so my knowledge only goes so far with PowerBi but my intutive thinking is telling me that my POWERBI team is going down the wrong rabbit hole to figure out the problem.    So my PowerBI team is trying to build a Direct Query report that connected to our SNOWFLAKE data warehouse.  When my PowerBi reporting team generates the report they are able to view the report with no issues but as soon as me (USER END or any other USER END) errors pop up:

Couldn't load the data for this visual

The credentials provided for the Snowflake source are invalid. (Source at ***REMOVE FOR PRIVACY***us-2.azure.snowflakecomputing.com;FAMS_WH.). The exception was raised by the IDbCommand interface.

My PowerBi team seem to think that the errors are being generated due to a certain settting in PowerBi but my gut feeling is telling me that snowflake is dening access to viewing the data to the USER-END only.  Everyone on the POWERBI team is able to view the POWERBI report with the direct query to snowflake with no issue and I'm guessing its since they have privileges to snowflake data warehouse.   

My PowerBi team was showing me via TEAM SHARE SCREEN that they were giving me unrestricted access to the data via PowerBi setting but that didnt work.  

What advise can I give my PowerBi team to make the DATA viewable to the END USER?  Or is this  a snowflake issue were they need to provide the END USER privileges to snowflake data warehouse

Again I'm not a POWER BI expert and I'm just trying to help my powerbi team.   Any suggestion I can give to them?

Screenshot: 

[lbendlin]

Did your Power BI team enable Single Sign On (SSO) for the Snowflake data source across your capacity?

[Anonymous]

@lbendlin thanks for the suggestion.  Yes according to my powerbi team "Yes, snowflake is SSO"

Any other ideas? 

[Zivarus]

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.