Power Query M Function

Value.NativeQuery Function

Pinterest LinkedIn Tumblr

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).

Value.NativeQuery Function

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 DescriptionRemarks
target as anyMandatory
query  as textMandatory
parameters  as anyOptional
options  as nullable recordOptional

Usage Notes

  • The Output of this function is defined the target(s).

Related Posts

Write A Comment