Solved: Re: Python Connector Issue

ajay_gajree · ‎10-03-2022

Details: "ADO.NET: Python script error.
<pi>C:\Users\ajay_\anaconda3\lib\site-packages\numpy\__init__.py:148: UserWarning: mkl-service package failed to import, therefore Intel(R) MKL initialization ensuring its correct out-of-the box operation under condition when Gnu OpenMP had already been loaded by Python process is not assured. Please install mkl-service package, see http://github.com/IntelPython/mkl-service
  from . import _distributor_init
Traceback (most recent call last):
  File "C:\Users\ajay_\PythonScriptWrapper_bf16526f-5fac-49c5-a94f-0987ef217f09\PythonScriptWrapper.PY", line 2, in <module>
    import os, pandas, matplotlib
  File "C:\Users\ajay_\anaconda3\lib\site-packages\pandas\__init__.py", line 16, in <module>
    raise ImportError(
ImportError: Unable to import required dependencies:
numpy: 

IMPORTANT: PLEASE READ THIS FOR ADVICE ON HOW TO SOLVE THIS ISSUE!

Importing the numpy C-extensions failed. This error can happen for
many reasons, often due to issues with your setup or how NumPy was
installed.

We have compiled some common reasons and troubleshooting tips at:

    https://numpy.org/devdocs/user/troubleshooting-importerror.html

Please note and check the following:

  * The Python version is: Python3.9 from "C:\Users\ajay_\anaconda3\python.exe"
  * The NumPy version is: "1.21.5"

and make sure that they are the versions you expect.
Please carefully study the documentation linked above for further help.

Original error was: DLL load failed while importing _multiarray_umath: The specified module could not be found.

</pi>"

Hi All

I am attempted to use the Python connector in Power BI for the first time, I set up an environment using Anaconda using the following commands

(base) C:\Users\ajay_>conda create -n new_env_pbi python==3.7
Proceed ([y]/n)? y
(base) C:\Users\ajay_>conda activate new_env_pbi
(new_env_pbi) C:\Users\ajay_>pip install pandas
(new_env_pbi) C:\Users\ajay_> pip install seaborn

I then tried to use the Python Connector in Power BI Desktop using this and got the above error

import pandas as pd
df = pd.read_csv ("C:/Users/ajay_/OneDrive/Desktop/Files/Power BI/Courses/Python Courses/Python for Power Bi Users/HR_file.csv")

Anyone seen this before and can you see what I may have done wrong?

ajay_gajree · ‎10-04-2022

Thank you for the reply

I now get this error

Details: "ADO.NET: Python script error.
<pi>C:\Users\ajay_\anaconda3\lib\site-packages\numpy\__init__.py:148: UserWarning: mkl-service package failed to import, therefore Intel(R) MKL initialization ensuring its correct out-of-the box operation under condition when Gnu OpenMP had already been loaded by Python process is not assured. Please install mkl-service package, see http://github.com/IntelPython/mkl-service
  from . import _distributor_init
Traceback (most recent call last):
  File "C:\Users\ajay_\PythonScriptWrapper_f6d6f88d-c83a-4497-899e-8dd8fea870ce\PythonScriptWrapper.PY", line 2, in <module>
    import os, pandas, matplotlib
  File "C:\Users\ajay_\anaconda3\lib\site-packages\pandas\__init__.py", line 16, in <module>
    raise ImportError(
ImportError: Unable to import required dependencies:
numpy: 

IMPORTANT: PLEASE READ THIS FOR ADVICE ON HOW TO SOLVE THIS ISSUE!

Importing the numpy C-extensions failed. This error can happen for
many reasons, often due to issues with your setup or how NumPy was
installed.

We have compiled some common reasons and troubleshooting tips at:

    https://numpy.org/devdocs/user/troubleshooting-importerror.html

Please note and check the following:

  * The Python version is: Python3.9 from "C:\Users\ajay_\anaconda3\python.exe"
  * The NumPy version is: "1.21.5"

and make sure that they are the versions you expect.
Please carefully study the documentation linked above for further help.

Original error was: DLL load failed while importing _multiarray_umath: The specified module could not be found.

</pi>"

View solution in original post

v-chenwuz-msft · ‎10-04-2022

Hi @ajay_gajree ,

Please use "//" in a string path.

Please try this code:

df = pd.read_csv ("C:\\Users\\ajay_\\OneDrive\\Desktop\\Files\\Power BI\\Courses\\Python Courses\\Python for Power Bi Users\\HR_file.csv")

Best Regards

Community Support Team _ chenwu zhu

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

ajay_gajree · ‎10-04-2022

Thank you for the reply

I now get this error

Details: "ADO.NET: Python script error.
<pi>C:\Users\ajay_\anaconda3\lib\site-packages\numpy\__init__.py:148: UserWarning: mkl-service package failed to import, therefore Intel(R) MKL initialization ensuring its correct out-of-the box operation under condition when Gnu OpenMP had already been loaded by Python process is not assured. Please install mkl-service package, see http://github.com/IntelPython/mkl-service
  from . import _distributor_init
Traceback (most recent call last):
  File "C:\Users\ajay_\PythonScriptWrapper_f6d6f88d-c83a-4497-899e-8dd8fea870ce\PythonScriptWrapper.PY", line 2, in <module>
    import os, pandas, matplotlib
  File "C:\Users\ajay_\anaconda3\lib\site-packages\pandas\__init__.py", line 16, in <module>
    raise ImportError(
ImportError: Unable to import required dependencies:
numpy: 

IMPORTANT: PLEASE READ THIS FOR ADVICE ON HOW TO SOLVE THIS ISSUE!

Importing the numpy C-extensions failed. This error can happen for
many reasons, often due to issues with your setup or how NumPy was
installed.

We have compiled some common reasons and troubleshooting tips at:

    https://numpy.org/devdocs/user/troubleshooting-importerror.html

Please note and check the following:

  * The Python version is: Python3.9 from "C:\Users\ajay_\anaconda3\python.exe"
  * The NumPy version is: "1.21.5"

and make sure that they are the versions you expect.
Please carefully study the documentation linked above for further help.

Original error was: DLL load failed while importing _multiarray_umath: The specified module could not be found.

</pi>"