Running Python scripts in power BI with anaconda environment

Hi All,

I am new to Power BI and I have been trying to run a python script to load data. However, when I run a simple script, I am getting the following error:

Code:

Error: 

Details: "ADO.NET: Python script error.
<pi>C:\Users\sdingari\Anaconda3\envs\mybi\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 "PythonScriptWrapper.PY", line 2, in <module>
    import os, pandas, matplotlib
  File "C:\Users\sdingari\Anaconda3\envs\mybi\lib\site-packages\matplotlib\__init__.py", line 109, in <module>
    from . import _api, _version, cbook, docstring, rcsetup
  File "C:\Users\sdingari\Anaconda3\envs\mybi\lib\site-packages\matplotlib\rcsetup.py", line 27, in <module>
    from matplotlib.colors import Colormap, is_color_like
  File "C:\Users\sdingari\Anaconda3\envs\mybi\lib\site-packages\matplotlib\colors.py", line 51, in <module>
    from PIL import Image
  File "C:\Users\sdingari\Anaconda3\envs\mybi\lib\site-packages\PIL\Image.py", line 89, in <module>
    from . import _imaging as core
ImportError: DLL load failed while importing _imaging: The specified module could not be found.
</pi>"

I created an environment in anaconda and I am using that environment as my home directory in PowerBI.

I have mkl-service and pillow installed in my anaconda enviroment, now sure why there is an error.

Any help is greatly appreciated.

Thanks a lot.