Forum Discussion
Power BI Desktop Connectivity to Snowflake
When attempting to connect to a Snowflake warehouse using Power BI Desktop I am getting an error which indicates that the warehouse is suspended and no data is accessible, however, the warehouse is not suspended and is running. This happens for both import and direct query.
The warehouse has USAGE permissions set for PUBLIC and my user account is a SYSADMIN. I am using the latest versions of the ODBC driver and Power BI Desktop. The OS is Windows 10 1909.
Thanks.
3 Replies
- Greg_Deckler
Community Champion
dabrock385 Hard one to troubleshoot. You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET". - amitchandak
Super User
dabrock385 , refer to the last update of this issue
https://community.powerbi.com/t5/Issues/Snowflake-warehouse-is-not-suspended/idi-p/868075
See if this has some info :https://community.snowflake.com/s/question/0D50Z000094ewm8/i-cant-connect-from-power-bi-i-get-the-error-that-the-warehouses-is-suspended
If not resolved log an issue at - https://community.powerbi.com/t5/Issues/idb-p/Issues
Hi dabrock385,
Can you please share more detailed information and operation steps to help us clarify your scenario?
How to Get Your Question Answered Quickly
In addition, how you test with current connection string with other tools to confirm if these requests have been blocked by rules and policy on your device?
Add Power BI URLs to your allow list
Regards,
Xiaoxin Sheng
