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


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:

Reference Data

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