Forum Discussion

patrickhofman's avatar
patrickhofman
New Member
9 years ago
Solved

DataSource.Error when connecting to ADO.NET provider

I have been working on an own implementation of ADO.NET. It works quite well from Visual Studio, etc. but now I want to use it in Power BI Desktop.   I have registered the provider in the machine.c...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi patrickhofman,

    Based on your description, you specify ADO.NET provider as data source in Power BI Desktop, right? If that is the case, could you please post a screenshot about that how you connect to the ADO.NET data source from Power BI Desktop?  In this official article, I haven’t found that  ADO.NET provider is included in the supported data source list.

    In addition, you can go to File -> Options and settings -> Options -> Diagnostics and click "enable tracing", then connect to your data source and check the detailed logs in the traces folder.

    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi patrickhofman,

Based on your description, you specify ADO.NET provider as data source in Power BI Desktop, right? If that is the case, could you please post a screenshot about that how you connect to the ADO.NET data source from Power BI Desktop?  In this official article, I haven’t found that  ADO.NET provider is included in the supported data source list.

In addition, you can go to File -> Options and settings -> Options -> Diagnostics and click "enable tracing", then connect to your data source and check the detailed logs in the traces folder.

Thanks,
Lydia Zhang

  • patrickhofman's avatar
    patrickhofman
    New Member
    9 years ago

    Thanks @Lydia, that was very helpful. I have got things working now, so thanks a lot for your help.

     

    I have put some personal side marks to the answer I gave on the Stack Overflow question I have asked regarding the same issue. You can find it here.

  • dpombal's avatar
    dpombal
    Post Partisan
    8 years ago

    How can I specify a adodb 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
    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