Forum Discussion
"Error fetching data for this visual" in Snowflake
- 1 year ago
Hi Danyboyyy ,
Thank you for reaching out to Microsoft Fabric Community.
These steps might resolve the “Invalid credentials” and DirectQuery visual errors for non-workspace users in apps.
-
Grant Build permission on the dataset to the app audience users, navigate to Workspace which contains Dataset, click on Manage Permissions, Add users, Grant Build Access.
-
Enable SSO correctly:
-
Go to Workspace , click on dataset settings expand data source credentials.
-
Ensure “Use SSO via Azure AD” is enabled and “Use user's credentials” is checked.
-
-
Verify Snowflake access, Ensure app users have the right Snowflake roles and are not blocked by network policies.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!
-
Hi Danyboyyy ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you!!
- Danyboyyy1 year agoFrequent Visitor
Hey,
I did not forget but I'm afraid I have not yet. What I know for now is that "Build" was not the issue since it hasn't changed anything.
I still have to have confirm for SSO and Snowflake access. Then i'll come back here 😉
Best,
- v-sathmakuri1 year ago
Community Support