ADO.NET: Python script error. memory allocation of 8192 bytes failed

[Anonymous]

I currently have a python script which uses the Polars library to create dataframes. At the end of my script, I convert these polars dataframes into pandas dataframes. And I have a total of 5 dataframes.

All the dataframes seem to load up in the navigator, but when I click on 'Load', it shows me the error below:

Does anyone know how to solve this issue? Thank you.

[Anonymous]

Hi, @Anonymous 

Have you solved the current problem?

Best Regards

Jianpeng Li

[Anonymous · Accepted solution]

Hi, @Anonymous 

As the error suggests, Power BI may not be able to allocate so much memory to execute the current python script. You can try to close other unnecessary applications, try to execute the current python script in a computer with more RAM. In addition, you can check whether the current python script processing is inefficient and takes up too much memory, causing the current problem.

Confirm that your current version of Power BI desktop is 64-bit, which will generally allow access to more memory.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.