Forum Discussion
'EnableFolding' isn't a valid option for this function. Valid options are: (none)
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).
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.
4 Replies
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.It's working for SQL Server or Postgre only.
Is there any other way for incremental refresh using oracle as a Source
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.
