cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

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.config already (both platforms) and have copied all relevant assemblies into the GAC. Now I was finally able to go around the first few error messages Power BI gave me, but now I am stuck at this one:

 

DataSource.Error: An error happened while reading data from the provider: 'Value cannot be null.
Parameter name: values'
Details:
DataSourceKind=AdoDotNet
DataSourcePath=MyOwnProvider/param1=Something

 

Now it seems to me this is a standard .NET error message, so that would be easy to solve if I know where it went wrong. Unfortunately I have found no way to diagnose the issue yet. I have tried using Visual Studio to debug Power BI (which seems to have successfully loaded my assembly). I have tried to use DebugView and ProcMon to see what happens, but all failed to give me anything useful.

 

How to diagnose what actually went wrong? How to get a detailed log, call stack, or whatever?

1 ACCEPTED SOLUTION

Accepted Solutions
Syndicate_Admin
Administrator
Administrator

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

View solution in original post

4 REPLIES 4
Syndicate_Admin
Administrator
Administrator

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

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.

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

 

Syndicate_Admin
Administrator
Administrator

Hola, a mí lo que me funcionó fue hacer instalar pycaret de esta manera: pip install -U --pre pycaret y fue siguiendo lo comentado en la siguiente direccion: https://stackoverflow.com/questions/72581460/installing-pycaret-library-not-completed-due-to-an-erro...

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,358)