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

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

  • gunjansa_ms's avatar
    gunjansa_ms
    Microsoft Employee
    6 years ago

    Hi, did we find solution for htis?

    I am having similar error. And how do we create environment for 3.6 and link it to powerbi?