AdoDotNet.DataSource

[beckyconning]

Hi! I need help with https://docs.microsoft.com/en-us/powerquery-m/adodotnet-datasource

Replies in the community from staff say to use custom connectors to connect to ADO.Net.

Also the documentation here https://github.com/microsoft/DataConnectors/blob/master/docs/m-extensions.md#data-source-functions says I can use AdoDotNet.DataSource in my custom connector.

However AdoDotNet.DataSource returns a table that has functions in it, and those functions take arguments of certain types but these functions don't have documentation?

I know the Power BI Postgres connector is based on ADO.Net, could we please have the source to use as a learning example as there are no examples of AdoDotNet.DataSource in https://github.com/microsoft/DataConnectors/tree/master/samples

Specced out a contract on the basis of the Microsoft Power BI documentation being correct so I'm really hoping that its true that its possible to connect to AdoDotNet data sources.

Thanks!

[macmac]

@beckyconning Have you foud any helpful information about using AdoDotNet.DataSource as a data source in Power Query custom connector implementation (https://learn.microsoft.com/en-us/power-query/install-sdk#installing-the-power-query-sdk) using Power Query SDK? I have own implementation of ADO.NET provider and after using it in Custom Connector implementation I catch the same problem as you described with returned tables as 4arguments functions and I can't operate on them inside implementation.  After more than year and half still no examples it (https://github.com/microsoft/DataConnectors/tree/master/samples) how to proceed with AdoDotNet.DataSource.

Any hint will be welcome.

Regards

Maciej

[MikeNitsenko]

Have you had any luck with additional info on AdoDotNet?DataSource? Struggling to make it work and found zero docs or examples for it.

[V-lianl-msft]

Hi @beckyconning ,

Hope these will help you:

https://www.codeproject.com/Articles/1870/Introduction-to-some-basic-classes-of-ADO-NET 

https://github.com/npgsql/npgsql/blob/ad2177cb024de97f27a210ba85c51a998afec7ef/src/Npgsql/NpgsqlTran... 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[macmac]

This answer is off topic. The problem is not in buiding ADO.NET provider but with using it inside Custom Connector implementation using  M langugage. I have not found either documentation or examples of how to proceed with the result of AdoNotNet.DataSource method.

Best Regards,

Maciej