Forum Discussion
Snowflake connection stuck on refresh
Hi,
I have a snowflake direct import dataset connected to power bi. In the desktop app, I can no longer refresh it. It gets stuck on refresh after it loads the expected number of rows. I have tried clearing the cache, restarting my computer, restarting power bi but nothing works. I tried having it run for 24 hours and that didn't work either. The dataset has refreshed just fine before, and in snowflake it says the query was a success, taking about 9 minutes.
Hi smparnon ,
Thank you for reaching out to Microsoft Community.If you're experiencing refresh issues with your Snowflake dataset in Power BI Desktop, consider the following steps:
Roll Back or Patch Power BI Desktop Some recent builds may have Snowflake connector bugs. Try rolling back to a previous version or install the latest patch if available.
Switch to Snowflake ODBC Driver The built-in connector has known limitations with MFA and caching. Using the Snowflake ODBC Driver can provide more stability. Ensure you install the driver architecture (32-bit or 64-bit) that matches your Power BI Desktop setup. Power Query Snowflake connector - Power Query | Microsoft Learn
Verify Gateway Updates If a gateway is part of your setup, make sure it's up-to-date. An outdated gateway, even if appearing connected can still block refreshes. ODBC Driver | Snowflake Documentation
Check Troubleshooting Resources Explore Microsoft’s detailed Power BI refresh troubleshooting guide to pinpoint specific scenarios. Troubleshoot refresh scenarios - Power BI | Microsoft Learn
Best Regards,
Chaithra E.
4 Replies
Hi smparnon ,
Thank you for reaching out to Microsoft Community.If you're experiencing refresh issues with your Snowflake dataset in Power BI Desktop, consider the following steps:
Roll Back or Patch Power BI Desktop Some recent builds may have Snowflake connector bugs. Try rolling back to a previous version or install the latest patch if available.
Switch to Snowflake ODBC Driver The built-in connector has known limitations with MFA and caching. Using the Snowflake ODBC Driver can provide more stability. Ensure you install the driver architecture (32-bit or 64-bit) that matches your Power BI Desktop setup. Power Query Snowflake connector - Power Query | Microsoft Learn
Verify Gateway Updates If a gateway is part of your setup, make sure it's up-to-date. An outdated gateway, even if appearing connected can still block refreshes. ODBC Driver | Snowflake Documentation
Check Troubleshooting Resources Explore Microsoft’s detailed Power BI refresh troubleshooting guide to pinpoint specific scenarios. Troubleshoot refresh scenarios - Power BI | Microsoft Learn
Best Regards,
Chaithra E.Hi smparnon ,
We would like to confirm if you've successfully resolved this issue or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E.Hi smparnon ,
We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.
Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E.Hi smparnon ,
We wanted to follow up to see if the issue you reported has been fully resolved. If you still have any concerns or need additional support, please don’t hesitate to let us know, we’re here to help.
We truly appreciate your patience and look forward to assisting you further if needed.
Warm regards,
Chaithra E.