getting error while passing the date parameter in the advance editor

[Anonymous]

Hello,

I am passing the date parameter in the query however it is giving me an error "Native queries aren't supported by this value"

below is the query.

[NimaiAhluwalia · Accepted solution]

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

[Anonymous · Accepted solution]

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.

[Anonymous]

I think the problem is not with the ODBC connector.

If i dont pass the parameter in the sql statement it is runnning fine as soon as i include the parameter it is giving me an error.

[NimaiAhluwalia]

Follow this below document if you want to pass the parameter in the Advance Editor using the M query

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters#:~:text=In....

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

Regards,

Nimai Ahluwalia

[NimaiAhluwalia · Accepted solution]

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