'EnableFolding' isn't a valid option for this function. Valid options are: (none)

[Ahsan_Nadeem]

I am trying to configure Incremetnal Refresh, below error is occuring. Below is the expression which I am using to enable Query Fodling

Value.NativeQuery(Oracle.Database("abc") ,"select * from xyz" ,null,[EnableFolding = true] )

'EnableFolding' isn't a valid option for this function. Valid options are: (none).

[v-eqin-msft · Accepted solution]

Hi @Ahsan_Nadeem ,

By default, native query folding is enabled. Operations that are capable of folding will be applied on top of your native query according to normal Import or Direct Query logic. Native Query folding isn't applicable with optional parameters present in Value.NativeQuery().

So please try to just remove [EnableFolding=true] from query.

 Here is an excellent blog post about using Value.NativeQuery() function and providing explicit value TRUE for the EnableFolding argument. And as he mentioned, this only works for SQL Server and Postgres at the time of writing

For more information, please kindly refer to:

Power Query PostgreSQL connector - Power Query | Microsoft Docs

Power Query Oracle database connector - Power Query | Microsoft Docs

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

[JirkaZ]

It's working for SQL Server or Postgre only.

[Ahsan_Nadeem]

Is there any other way for incremental refresh using oracle as a Source

[JirkaZ]

Oracle is supported as a data source with incremental refresh capabilities. You'll achieve the folding by not using a custom query and use standard connection and transformation steps. Just be careful not to use transformations that disable folding.