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

govind_021's avatar
govind_021
Super 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.