AdoDotNet.DataSource

Updated on

AdoDotNet.DataSource is a Power Query M function that retrieves the schema collection for an ADO.NET data source with a specified provider name and connection string. The function returns the schema collection for the ADO.NET data source with optional parameters for command timeout and SQL-compatible Windows authentication.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

AdoDotNet.DataSource(
   providerName as text,
   connectionString as any,
   optional options as nullable record,
) as table

Description

Returns the schema collection for the ADO.NET data source with provider name providerName and connection string connectionString. 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.
  • TypeMap

Other functions related to AdoDotNet.DataSource are:

BI Gorilla Blog

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/adodotnet-datasource