Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Does Power BI support Python 3.7.4 ?

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 ?

 

3 Replies

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support

    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

     

  • Yes it does.

     

    Install latest version Power BI Desktop

    Install pandas and matplotlib packages in python

    Edit the system environment variables

    • kopa6's avatar
      kopa6
      Frequent Visitor

      What happens if you can't edit teh system variables? I.e the buttons are greyed out.