I am trying to configure Incremetnal Refresh, below error is occuring. Below is the expression which I am using to enable Query FodlingValue.NativeQuery(Oracle.Database("abc") ,"select * from xyz" ,null,[EnableFolding = true] )'EnableFolding' isn't a valid option for this function. Valid options are: (none).

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 QinIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Forum Discussion

Related content

PowerBI EnableFolding

EnableFolding error

PowerBI EnableFolding

Datatable options

DATESYTD function