cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dpombal Member
Member

How to get data from Microsoft ADO data source PIOLEDB from Osisoft

How can I specify a ado connection from Microsoft PowerBI ?

 

import adodbapi,

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 2.6.0.7 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

 

 

Regards

1 REPLY 1
Community Support Team
Community Support Team

Re: How to get data from Microsoft ADO data source PIOLEDB from Osisoft

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:

https://powerbi.microsoft.com/fr-fr/blog/power-bi-user-group-custom-connector/

 

Regards,

Jimmy Tao