Hybrid Tables, Snowflake and Query Folding

[Nosferatus2k]

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!

[maqister · Accepted solution]

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!

[Don_Miguel]

Hello @maqister,
Are Hybrid tables in GA now?
could not find official documentation.
Thanks!

[amitchandak]

@Nosferatus2k , if this is just select *, then try use direct table name or view name and try

[Nosferatus2k]

I've tried that also. Same thing.

[v-easonf-msft]

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

[Nosferatus2k]

Hi @v-easonf-msft ,

Thanks for the links! None of them did help.

Cheers,