Power Query M Value.NativeQuery Function is categorized under Value Functions. This function is used to evaluate the provided query(s) against the target(s) by using specified parameters(s).
Purpose of Power Query M Value.NativeQuery Function
This function is used to evaluate the query.
Return value
This function returns a query.
Syntax
=Value.NativeQuery(target,query,parameters,options)
Arguments
| Arguments | Description | Remarks | ||
| target | as any | Mandatory | ||
| query | as text | Mandatory | ||
| parameters | as any | Optional | ||
| options | as nullable record | Optional |
Usage Notes
- The Output of this function is defined the target(s).