Snowflake warehouse (is not) suspended

[Anonymous]

I'm trying to connect to Snowflake. I'm able to do this with various other tools just fine. I connect via Power BI and it will show sample data and show all of my column names in the Fields section, but when I add anything to the visual I get an error the warehouse is suspended. Google has turned up nothing but possible permissions issues, which is not the case here. 

How can I get Power BI to allow me to use my Snowflake data?

[v-qiuyu-msft]

Hi @Anonymous, 

Which kind of connection mode do you use when connecting to Snowflake, import or DirectQuery? 

If it's DirectQuery mode, please change it to import mode then test again to see if the same issue occurs. 

Best Regards,

Qiuyun Yu

[Anonymous]

I am using DirectQuery. This is a large database that I need to query varying timeframes and levels of granularity, so import isn't really a good option. Does PowerBI not play well with Snowflake in DirectQuery mode?

[v-qiuyu-msft]

Hi @Anonymous, 

As you are using DirectQuery, when you drag fields to any visual, Power BI retrieves data from Snowflake. In your scenario, I would suggest you check if the Snowflake is suspended at the time that you create visuals in Power BI. See: https://docs.snowflake.net/manuals/user-guide/warehouses-tasks.html#suspending-a-warehouse

Best Regards,
Qiuyun Yu

[Anonymous]

The warehouse is not suspended. I'm able to run queries with several other tools just fine at the same time I'm receiving this error from Power BI. I never run into this problem with any other tool, but cannot do anything in Power BI because it returns this error every time.

[estetoro-mm]

Adding an answer since this hasn't been properly resolved and I ran into the same (infuriating) issue.

The problem is that the default role you are logging in with does not have usage permissions on the warehouse you are trying to use.  The solution is to make sure the default role for the user you are logging in with has usage permissions on the warehouse that you type in to the Power BI.  Once that is resolved, you will stop getting the spurious "warehouse is suspended" error.    

This problem still occurs if your user has access to the warehouse under a different role.  You must make sure that the default role for that user has access to the warehouse.

[billramo]

BUG FIX REQUEST: Please don't check for Usage permissions to see if the warehouse is suspended.

I have three active Snowflake customers that all use the Auto Resume feature. It's apparent that Power BI during the Get Data process skips this check because it can enumerate the schemas and tables just fine with a warehouse confiured with Auto-Resume. However, the Data Preview pane fails to show the data because of the check to see if the instance is connected.

Thanks,

Bill

[jorge-gt3]

I had the exact same issue and everything started working after installing both ODBCs listed on this page.

https://docs.snowflake.com/en/user-guide/odbc-windows.html

At first I installed only the 64bit one, but it didnt work, so I tried the 32bit one and everything started working after restarting PowerBI.