Power BI Desktop - error while refreshing report

[ashishdesh]

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 -

[ashishdesh · Accepted solution]

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.

[govind_021]

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
   
   
   

[ashishdesh]

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.

[danextian]

Hi @ashishdesh 

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.