Can not run Python script in powerbi desktop

[thuantv]

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

[RClayton_100]

You probably already have all of the necessary modules properly installed, especially if you can use them outside of Power BI.

SO......., Under options and settings, in Python Scripting, check your Python home directory.

I had to change mine from C:\Users\<......my user name....>\AppData\Local\Programs\Python\Python39

                                   to C:\Users\<......my user name....>\AppData\Local\Programs\Python\Python38-32

[v-xicai · Accepted solution]

Hi @thuantv ,

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.

[amitchandak]

@thuantv , I doubt python installation is not complete. Install the required libraries.

Few doc about setup

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-scripts
https://en.blog.businessdecision.com/how-to-use-the-python-integrator-in-powerbi/
https://towardsdatascience.com/using-python-in-power-bi-ee95a6b71443
https://powerbi.microsoft.com/en-us/blog/python-visualizations-in-power-bi-service/

https://powerbi.microsoft.com/en-us/blog/python-visualizations-in-power-bi-service/
https://www.ahaapps.com/microsoft-power-bi-service-with-python-visualizations/

[Greg_Deckler]

@thuantv - Seems like you are missing a package installation, specifically, "mkl-service"