Forum Discussion

ajay_gajree's avatar
ajay_gajree
Helper I
3 years ago
Solved

Python Connector Issue

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's avatar
    ajay_gajree
    3 years ago

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

2 Replies

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

    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's avatar
      ajay_gajree
      Helper I

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