Forum Discussion

PrestaPower's avatar
PrestaPower
Frequent Visitor
7 years ago

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 yo...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

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's avatar
    PrestaPower
    Frequent Visitor
    7 years ago

    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's avatar
    PrestaPower
    Frequent Visitor
    7 years ago

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