Python script, data load, ADO.NET error

[PrestaPower]

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.

[v-piga-msft]

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

[PrestaPower]

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).

[PrestaPower]

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]

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