cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PrestaPower
Frequent Visitor

Python script, data load, ADO.NET error

Hi all, 

 

i have an error happening when loading data with a python script:

We encountered an error while processing your python script.

Details: "ADO.NET: A problem occurred while processing your Python script.
Here are the technical details: Process must exit before requested information can be determined."

 

The thing is that the first time it actually worked, but not anymore.

I was wondering if it could be related to a tim-out issue.

 

Also my script also exports one of the tables on share point as an excel file and this actually works fine.

As a side note we use anaconda evironment for our company purposes.

 

4 REPLIES 4
PrestaPower
Frequent Visitor

Re: Python script, data load, ADO.NET error

Also, when i run it on my laptop, the error is not showed, but on our virtual machine it is.

v-piga-msft Resident Rockstar
Resident Rockstar

Re: Python script, data load, ADO.NET error

Hi @PrestaPower ,

If it is convenient, could you share more details?(e.g, python version, desktop version, datasource you connect)

In addition, you could refer to this similar thread.

Best Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
PrestaPower
Frequent Visitor

Re: Python script, data load, ADO.NET error

hi @v-piga-msft,

 

the python version i'm using is 3.6. As Power BI, on the virtual machine is  2.70.5494.562 64-bit (June 2019) and on my computer is 2.70.5494.761 64-bit (June 2019).

The python code itself fetch data from the SQL database and also two excel files.

 

On the Virtual machine, it doesn't work, but on my computer it does, even if it's slow.

 

I don't know if it could be the reason, but the virtual machine might not be the more powerful, as when i try to run the script in PBI, my cpu use is at 100% and the memory use around 60%

 

Regards, 

 

theo

PrestaPower
Frequent Visitor

Re: Python script, data load, ADO.NET error

I used swifer, which makes my code run 2 times faster on spyder (around 6 minutes), but on the virtual machine, when using this same code with power bi, i always reach the time out (30 minutes).

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors