| title | ms.date | ms.service | ms.reviewer | ms.topic | author | ms.author |
|---|---|---|---|---|---|---|
Value.NativeQuery | Microsoft Docs |
4/16/2018 |
powerquery |
gepopell |
reference |
dougklopfenstein |
bezhan |
Value.NativeQuery(target as any, query as text, optional parameters as any, optional options as nullable record) as any
Evaluates query against target using the parameters specified in parameters and the options specified in options.
The output of the query is defined by target.
target provides the context for the operation described by query.
query describes the query to be executed against target. query is expressed in a manner specific to target (e.g. a T-SQL statement).
The optional parameters value may contain either a list or record as appropriate to supply the parameter values expected by query.
The optional options record may contain options that affect the evaluation behavior of query against target. These options are specific to target.