Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Error when connecting python to PBI

  Hi, Despite the fact that I do have Python installed when I'm trying to connect it to PBI I get an error message:   Unable to connect: Details: "ADO.NET: Python script error. Traceback (most ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    As I found out yestreday the issue was due to Power Bi not supporting Python 3.7. i had to created new env for py36 and it worked form there!

     

    Thank you

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Yes it is the same :

 

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

Since you have two different release of Python, I'm afraid the Numpy is in Python37 rather than in the Anaconda. Please check out. You can do it like below.

pip list -v

Error-when-connecting-python-to-PBI

 

Best Regards,
Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    As I found out yestreday the issue was due to Power Bi not supporting Python 3.7. i had to created new env for py36 and it worked form there!

     

    Thank you

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi,

       

      I have installed Python3.6 together with pandas, numpy in the same folder but this error below still persist.

      What else could have caused this error, please advise.

       

       

      DataSource.Error: ADO.NET: Python script error.
      Traceback (most recent call last):
      File "PythonScriptWrapper.PY", line 2, in <module>
      import os, pandas, matplotlib
      ModuleNotFoundError: No module named 'matplotlib'

      Details:
      DataSourceKind=Python
      DataSourcePath=Python
      Message=Python script error.
      Traceback (most recent call last):
      File "PythonScriptWrapper.PY", line 2, in <module>
      import os, pandas, matplotlib
      ModuleNotFoundError: No module named 'matplotlib'

      ErrorCode=-2147467259
      ExceptionType=Microsoft.PowerBI.Scripting.Python.Exceptions.PythonScriptRuntimeException

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        hi, is actually Power BI now supporting  Pyhton 3.7 I am having the sam error.

        Details: "ADO.NET: Python script error.
        Traceback (most recent call last):
        File "PythonScriptWrapper.PY", line 4, in <module>
        import matplotlib.pyplot
        File "C:\USERS\SARMIENTOF\APPDATA\ROAMING\CONTINUUM\ANACONDA3\lib\site-packages\matplotlib\pyplot.py", line 32, in <module>
        import matplotlib.colorbar
        File "C:\USERS\SARMIENTOF\APPDATA\ROAMING\CONTINUUM\ANACONDA3\lib\site-packages\matplotlib\colorbar.py", line 32, in <module>
        import matplotlib.contour as contour
        File "C:\USERS\SARMIENTOF\APPDATA\ROAMING\CONTINUUM\ANACONDA3\lib\site-packages\matplotlib\contour.py", line 18, in <module>
        import matplotlib.font_manager as font_manager
        File "C:\USERS\SARMIENTOF\APPDATA\ROAMING\CONTINUUM\ANACONDA3\lib\site-packages\matplotlib\font_manager.py", line 48, in <module>
        from matplotlib import afm, cbook, ft2font, rcParams, get_cachedir
        ImportError: DLL load failed: The specified module could not be found.
        "

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      How can you create an environment in python 3.6? what needs to change in order to do this?