Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Python integration error

Hi, I was giong through the documentation on setting up the python integration for Power BI, found here: Using Python in Power BI Power Query Editor - Power BI | Microsoft Docs   But when I try an...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    //note:You'll need to have the pandas library installed in your Python environment for the previous script code to work properly. To install pandas, run the following command in your Python installation: | > pip install pandas

    Please install the pandas library and restart your computer and try again.

    # 'dataset' holds the input data for this script

import pandas as pd
completedData = dataset.fillna(method='backfill', inplace=False)
dataset["completedValues"] =  completedData["SMI missing values"]

    How To Install Pandas In Python? An Easy Step By Step Multimedia Guide

     

    My environment at the time of testing.

    python 3.10

    Desktop Version: 2.106.883.0 64-bit (June 2022)

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

Anonymous's avatar
Anonymous
Not applicable
4 years ago

New error now, after removing indentations, I am getting this error:

 

DataSource.Error: ADO.NET: Python script error.
<pi>C:\USERS\DSALMONS\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\dsalmons\PythonScriptWrapper_a7538157-163f-44f8-a836-995f2677be9b\PythonScriptWrapper.PY", line 2, in <module>
import os, pandas, matplotlib
File "C:\USERS\DSALMONS\ANACONDA3\lib\site-packages\pandas\__init__.py", line 16, in <module>
raise ImportError(
ImportError: Unable to import required dependencies:


I have tried installing the mkl-service package using the github link, but it still gives me the same error