Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Can not run Python script in powerbi desktop

I have create csv file named "dataset" and write a python script to import it to Powerbi desktop. When I get data in powerbi desktop and paste above script, PBI show the error as following: "Details: "ADO.NET: Python script error. C:\Users\Admin\anaconda3\lib\site-packages\numpy_init.py:140: 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 "PythonScriptWrapper.PY", line 2, in import os, pandas, matplotlib File "C:\Users\Admin\anaconda3\lib\site-packages\pandas_init.py", line 17, in "Unable to import required dependencies:\n" + "\n".join(missing_dependencies) ImportError: Unable to import required dependencies" My python script is: "import pandas as pd import numpy as np import matplotlib from matplotlib import pyplot as plt df = pd.read_csv(r'C:\Users\Admin\Desktop\Python\Python_to_powerbi\Dataset.csv') print(df)" And I also attach my csv file. target=_blank> For more information I use Anaconda with python version is 3.7.4 and Numpy version is 1.18.1 Matplotlib is also installed Please help me to fix this integration error. Many [thanks]
  • v-xicai's avatar
    v-xicai
    5 years ago

    Hi Anonymous ,

     

    According to the error message, you may install a package named "mkl-service", and then see if there will be other errors.

     

    There are also several points you may considerate for the Python data source:

     

    1.Try to install Python on your local machine,  download the latest version of Python from the Python website .

     

    2.Install required Python packages,

     

    pip install pandas

pip install matplotlib

     

    3.Go to File > Options and settings > Options > Python scripting, enable Python scripting .

     

    4.When setting the working directory within the Python script, you must define a full path to the working directory, rather than a relative path

     

    5.When publish to Power BI Service, to refresh the Python data source, you may need to install the on premise data gateway (personal mode) .

     

    For reference:

     

    Run Python scripts in Power BI Desktop

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

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

4 Replies