Power Query
Search…
published
Introduction
Accessing Data
Action
Binary
Binary Formats
Combiner
Comparer
Cube
Date
Date Time
Date Time Zone
Diagnostics
Duration
Error
Expression
Function
Lines
List
Logical
Metadata
Number
Record
Replacer
Splitter
Table
Text
Time
Type
Uri
Values
DirectQueryCapabilities.From
Embedded.Value
Html.Table
Pdf.Tables
Resource.Access
SqlExpression.SchemaFrom
SqlExpression.ToExpression
Value.Add
Value.As
Value.Compare
Value.Divide
Value.Equals
Value.Firewall
Value.Is
Value.Multiply
Value.NativeQuery
Value.NullableEquals
Value.ReplaceType
Value.ResourceExpression
Value.Subtract
Value.Type
Variable.Value
Web.BrowserContents
Powered By GitBook
Value.NativeQuery

Value.NativeQuery

Evaluates a query against a target.
function (optional target as nullable any, query as text, optional parameters as nullable any, optional options as nullable record) as nullable any

Description

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.

Category

Values
Previous
Value.Multiply
Next
Value.NullableEquals
Copy link
Contents
Value.NativeQuery
Description
Category