How can I specify a ado connection from Microsoft PowerBI ?
I am using python library to connect to a datasource like this
"Provider=PIOLEDB;Data Source=serverIP;Persist Security Info=False;Integrated Security=SSPI"
adodbapi 188.8.131.52 python library
A pure Python package implementing PEP 249 DB-API using Microsoft ADO.
I see there is a M powerquery function to connect
AdoDotNet.Query(providerName as text, connectionString as any, query as text, optional options as nullable record) as table
Hi dpombal ,
Currently, power bi doesn’t support ADO.NET data source with built-in connectors. You can use custom connectors to connect to ADO.NET data source. Please refer to: