getting error while passing the date parameter in the advance editor

Hello Anonymous 

We need to install Snowflakes ODBC driver in advance to connect SnowFlakes server.

Try viewing these posts as it might help

https://community.powerbi.com/t5/Service/quot-Native-queries-aren-t-supported-by-this-value-quot-When/m-p/2227945/highlight/true

IF MY SOLUTION HELPED YOU PLEASE DO HIT A LIKE AND ACCEPT IT AS A SOLUTION IF IT SOLVES YOUR ERROR!

Regards,

Nimai Ahluwalia

Hi  Anonymous ,

There may be a query folding problem.

Are you using a native database query when connecting to Snowflake, and if so, there are some limitation on query folding:

Query folding while using a native database query is limited to the PostgreSQL connector only. No other connectors support query folding if you use a native database query. Also, for folding to work in the PostgreSQL connector, the native database query you enter has to work as a subquery.

Please note the "Query Folding" relates to whether the Client or the Server is using the CPU to process the query. If the data source supports Query folding, the database CPU can be used to process the query then return the results. If Query folding is not supported, not hosted on the database, there means that you need to return all the data from the Datasource to your Local Client to process the query. 

You can check if Query folding is supported here:

https://docs.microsoft.com/en-us/power-query/power-query-folding#determine-when-a-query-can-be-folded

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.