Forum Discussion
Hybrid Tables, Snowflake and Query Folding
Hello,
I'm trying to use the Public Preview of Hybrid Tables in Power BI Premium.
First I'm connecting to Snowflake from Power BI Desktop.
I'm using custom SQL to connect to snowflake, to enable the query folding, following instructions from here:
Custom SQL Now Supported in the Snowflake Connector for Power BI! - Snowflake Blog
When I click on a table in Power BI desktop, and want to set the incremental refresh, I'm not able to set the Hybrid table functionality because it says:
But query folding should be enabled and supported for Snowflake.
Even the first step of the table is:
Value.NativeQuery(Snowflake.Databases("myseversnowflakecomputing.com","COMPUTE_WH"){[Name="HYBRID_DEMO"]}[Data], "select * from ""MY_DB"".""PUBLIC"".""V_LINEITEM""", null, [EnableFolding=true])
Any ideas?
Thanks!
We had a bug blocking you from using hybrid tables on many popular datasources like snowflake, databricks, bq and more. The fix is out! Please download newest Desktop release. Sorry for the inconvinience!
6 Replies
maqisterMicrosoft Employee
We had a bug blocking you from using hybrid tables on many popular datasources like snowflake, databricks, bq and more. The fix is out! Please download newest Desktop release. Sorry for the inconvinience!
Hello maqister,
Are Hybrid tables in GA now?
could not find official documentation.
Thanks!
- amitchandak
Super User
Nosferatus2k , if this is just select *, then try use direct table name or view name and try
I've tried that also. Same thing.
- v-easonf-msft
Community Support
Hi, Nosferatus2k
Please check if these related threads could help:
Power BI Incremental Refresh with Snowflake
Does Snowflake support query folding when used as a data source by Power BI?
Query folding in Snowflake DirectQuery is failing
Best Regards,
Community Support Team _ Eason
