Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
When I try to intergrate my Python dataframe into Power BI I get the following message:
Details: "ADO.NET: Python script error.
Traceback (most recent call last):
File "PythonScriptWrapper.PY", line 2, in <module>
import os, pandas, matplotlib
File "P:\Distributor\lib\site-packages\pandas\__init__.py", line 17, in <module>
"Unable to import required dependencies:\n" + "\n".join(missing_dependencies)
ImportError: Unable to import required dependencies:
numpy: DLL load failed: The specified module could not be found.
"
I saw the post with the similar question and the solution was to use Python 3.6
https://community.powerbi.com/t5/Desktop/Error-when-connecting-python-to-PBI/td-p/593716
Was it not fixed yet ?
Yes it does.
Install latest version Power BI Desktop
Install pandas and matplotlib packages in python
Edit the system environment variables
What happens if you can't edit teh system variables? I.e the buttons are greyed out.
Hi @Anonymous ,
Yes , it supports python3.7.4. Would you please install the latest version of Power BI Desktop?
And please follow the path below to add for System Environment Variable PATH:
C:\Users\<myusername>\AppData\Local\Continuum\Anaconda3\Scripts\
C:\Users\<myusername>\AppData\Local\Continuum\Anaconda3\Library\
C:\Users\<myusername>\AppData\Local\Continuum\Anaconda3\Library\bin\
C:\Users\<myusername>\AppData\Local\Continuum\Anaconda3\Library\mingw-w64\bin\
For more details, please refer to https://community.powerbi.com/t5/Desktop/Microsoft-PowerBI-Scripting-Python-Exceptions/td-p/850714
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai