AdoDotNet.DataSource

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:

Reference Data

https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference

Power Query M Functions / Accessing Data Functions / AdoDotNet.DataSource