topic Re: Hybrid Tables, Snowflake and Query Folding in Desktop

Hybrid Tables, Snowflake and Query Folding

Nosferatus2k — Tue, 04 Jan 2022 12:40:56 GMT

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!

Re: Hybrid Tables, Snowflake and Query Folding

amitchandak — Tue, 04 Jan 2022 12:50:39 GMT

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

Re: Hybrid Tables, Snowflake and Query Folding

Nosferatus2k — Tue, 04 Jan 2022 12:54:39 GMT

I've tried that also. Same thing.

Re: Hybrid Tables, Snowflake and Query Folding

v-easonf-msft — Fri, 07 Jan 2022 08:33:23 GMT

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

Re: Hybrid Tables, Snowflake and Query Folding

Nosferatus2k — Sun, 09 Jan 2022 09:25:51 GMT

Hi v-easonf-msft ,

Thanks for the links! None of them did help.

Cheers,

Re: Hybrid Tables, Snowflake and Query Folding

maqister — Fri, 21 Jan 2022 23:02:25 GMT

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!

Re: Hybrid Tables, Snowflake and Query Folding

Don_Miguel — Tue, 28 Nov 2023 10:18:04 GMT

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