Forum Discussion

Danyboyyy's avatar
Danyboyyy
Frequent Visitor
1 year ago
Solved

"Error fetching data for this visual" in Snowflake

Hi,   Hope everyone is doing well.   There are several topics that deal with this error, but none that answers my problem.   Context : - a report and a semantic model that leverages the Direct...
Need Help
  • v-sathmakuri's avatar
    v-sathmakuri
    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.

    1. 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.

    2. 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.

    3. 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!!

v-sathmakuri's avatar
v-sathmakuri
Icon for Community Support rankCommunity Support
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.

  1. 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.

  2. 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.

  3. 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!!

  • Danyboyyy's avatar
    Danyboyyy
    Frequent Visitor
    1 year ago

    Hi,

     

    Thank you for your answer ! I'll try that and will come back to update the status 🙂

    • v-sathmakuri's avatar
      v-sathmakuri
      Icon for Community Support rankCommunity Support
      1 year ago

      Hi Danyboyyy ,

       

      Thank you for the response!! We will be waiting for your reply, Please let us know if you still face any issues?

      • Danyboyyy's avatar
        Danyboyyy
        Frequent Visitor
        1 year ago

        Hi v-sathmakuri ,

         

        I'm sorry I could not come sooner, I just only had the opportunity to check access with my business users.

         

        Turns out that the problem was actually fully related to Snowflake : the business users accounts had been disabled by the DBA. Everything works now that the users are enabled.

         

        For reference :

        - The build permission was not needed (they don't have it now and they can fully access the reports)

        - The SSO was already correctly enabled

         

        Thank you for your help and sorry again for how long it took for me to come back 🙂