Power Query
Search…
published
Introduction
Accessing Data
Access
Active Directory
Adobe Analytics
Ado Dot Net
AdoDotNet.DataSource
AdoDotNet.Query
Amazon Redshift
Analysis Services
Apache Spark
App Figures
Azure Enterprise
Azure Hive LLAP
Azure Spark
Azure Storage
Cdm
Cds
Com Score
Csv
Customer Insights
Data Lake
Data World
DB 2
Denodo
Document DB
Dremio
Dynamics 365 Business Central
Dynamics 365 Business Central On Premises
Dynamics 365 Financials
Dynamics Nav
Exasol
Excel
Exchange
Facebook
File
Folder
Github
Google Analytics
Google Big Query
Hdfs
Hd Insight
Impala
Informix
Jethro ODBC
Json
Kusto
Kyligence
Mail Chimp
Marketo
Marketplace
Microsoft Azure Consumption Insights
Mixpanel
My SQL
Netezza
O Data
Odbc
Ole Db
Oracle
Paxata
Planview Enterprise
Postgre SQL
Power BI
Projectplace
Python
Quick Books
R
R Data
Salesforce
Sap Business Warehouse
Sap Hana
Share Point
Smartsheet
Snowflake
Soda
Spark
Spark Post
Sql
Stripe
Sweet IQ
Sybase
Team Desk
Teradata
Troux
Twilio
Ty Graph
Vertica
VSTS
Web
Webtrends
Xml
Zendesk
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
Powered By GitBook
AdoDotNet.Query

AdoDotNet.Query

Returns the result of running a native query on an ADO.NET data source.
function (providerName as text, optional connectionString as nullable 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 which 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.

Category

Accessing data
Previous
AdoDotNet.DataSource
Next
Amazon Redshift
Last modified 3yr ago
Copy link
Contents
AdoDotNet.Query
Description
Category