Forum Discussion
'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.
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.