Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Power BI Desktop - error while refreshing report

Hi

 

I work with a team of Power BI developers. There are a couple of reports we've built a few months back and all our team members were able to refresh the report data in Desktop. Suddenly, since last few days, I am not able to refresh these reports. However, my other team members are able to refresh the exact same reports. Please suggest solution for this issue.

Thanks

 

Note - these reports pull data from Snowflake views.

 

When I hit refresh button, I get below error -

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    HI

     

    The problem has been solved. I changed my role in snowflake same as other team members (for whom refresh is working) and it worked. Thanks all for your response.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    HI

     

    The problem has been solved. I changed my role in snowflake same as other team members (for whom refresh is working) and it worked. Thanks all for your response.

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    1 year ago

    Hi Anonymous 

     

    How does this erring query look prior to loading? You're probably loading just types like list, tables, records, binary and other types that do not return a scalar value.

     

  • govind_021's avatar
    govind_021
    Icon for Super User rankSuper User
    1 year ago
    Hey , Please check for the following points
    1. Check your Snowflake access permissions; they might have been revoked or modified.
    2. Verify if the Snowflake views or tables have been altered, such as renamed or removed columns.
    3. Update the Power BI queries in Power Query Editor to match the current structure.
    4. Clear and reconnect to the data source in Power BI Desktop to refresh the metadata.
    5. Ensure your Power BI Desktop is up-to-date and there are no connectivity issues.
    6. Contact your Snowflake admin to review and resolve any permission-related issues.

      Best Regards,
      Govind Sapkade
      Data Analyst | Power BI Enthusiast | Microsoft PL 300 Certified Power BI Data Analyst | MS Fabric Enthusiast
      🎥 Subscribe to my youtube channel for hands on tutorials : YouTube

      📊 Let’s connect on Linkdin : Linkdin


    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi Govind

       

      Please see my response below -

       

      1. Check your Snowflake access permissions; they might have been revoked or modified. -- there has been no changes to my snowflake permissions. 
      2. Verify if the Snowflake views or tables have been altered, such as renamed or removed columns. -- no change to the snowflake tables or views. Other team members are able to refresh the same report from their machine.
      3. Update the Power BI queries in Power Query Editor to match the current structure. -- no change in the queries
      4. Clear and reconnect to the data source in Power BI Desktop to refresh the metadata. -- I removed the cache by going to File -> Options and settings -> Options -> Data Load -> Clear cache and it still didnt help
      5. Ensure your Power BI Desktop is up-to-date and there are no connectivity issues. -- it is up-to-date and dont see any connectivity issues. I am able to build new reports
      6. Contact your Snowflake admin to review and resolve any permission-related issues -- i am the admin myself for both Power BI and Snowflake. There has been no changes to the permissions.