AdoDotNet.Query is a Power Query M function that executes a query with a specified connection string and ADO.NET provider, returning the result. The function returns the result of running the query with optional parameters for command timeout and SQL-compatible Windows authentication.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
AdoDotNet.Query(
providerName as text,
connectionString as any,
query as text,
optional options as nullable record,
) as table
Description
Returns the result of running query
with the connection string connectionString
using the ADO.NET provider providerName
. connectionString
can be text or a record of property value pairs. Property values can either be text or number. An optional record parameter, options
, may be provided to specify additional properties. The record can contain the following fields:
CommandTimeout
: A duration that controls how long the server-side query is allowed to run before it is canceled. The default value is ten minutes.SqlCompatibleWindowsAuth
: A logical (true/false) that determines whether to produce SQL Server-compatible connection string options for Windows authentication. The default value is true.
Related functions
Other functions related to AdoDotNet.Query are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy