topic Re: Python Integration Error in Custom Visuals Development Discussion

Python Integration Error

Anonymous — Thu, 25 Apr 2019 06:21:51 GMT

Hi All,

I am getting the following error while using python visual. I made use of anaconda distribution for python installation.

Following is the error :

Error Message:
Python script error.
Traceback (most recent call last):
File "PythonScriptWrapper.PY", line 2, in <module>
import os, matplotlib.pyplot, uuid, pandas
File "C:\Users\jasKsing\AppData\Local\Continuum\anaconda3\lib\site-packages\matplotlib\__init__.py", line 141, in <module>
from . import cbook, rcsetup
File "C:\Users\jasKsing\AppData\Local\Continuum\anaconda3\lib\site-packages\matplotlib\cbook\__init__.py", line 33, in <module>
import numpy as np
File "C:\Users\jasKsing\AppData\Local\Continuum\anaconda3\lib\site-packages\numpy\__init__.py", line 140, in <module>
from . import _distributor_init
File "C:\Users\jasKsing\AppData\Local\Continuum\anaconda3\lib\site-packages\numpy\_distributor_init.py", line 34, in <module>
from . import _mklinit
ImportError: DLL load failed: The specified module could not be found.

Following is the script :

# The following code to create a dataframe and remove duplicated rows is always executed and acts as a preamble for your script:

# dataset = pandas.DataFrame(FullDate, UnitPrice, Quantity)

# dataset = dataset.drop_duplicates()

# Paste or type your script code here:

import pip

import matplotlib.pyplot as plt

dataset.plot()

Following is the setting are options in power bi:

Kindly help 🙂

Re: Python Integration Error

Anonymous — Thu, 25 Apr 2019 18:40:29 GMT

@Anonymous ,

Do you know what version of Python your Anaconda environment is using? I was running into issues importing packages with 3.6 and 3.7.

I was able to get around the error by creating a new conda env with Python 3.5:

conda create -n py35 anaconda python=3.5

Then pip installing relevant packages (I had issues with PowerBI recognizing conda installs):

conda activate py35
pip install matplotlib
pip install pandas

After this is complete, you need to point PowerBI to the new env.

Including steps for those less familiar:

File -> Options and Settings -> Options -> Python Scripting

Then add the Path to your new Env. Mine looks like:

"C:\ProgramData\Anaconda3\envs\py35"

This thread tipped me off to the issue:

https://developercommunity.visualstudio.com/content/problem/362404/importerrordll-load-failed-the-specified-module-co.html

Let me know if you have questions.

Re: Python Integration Error

pkoetzing — Fri, 03 May 2019 18:22:45 GMT

I'm had exactly the same issue and error msg as @Anonymous . So I checked out @Anonymous 's recipe, but unfortunately it didn't work for me. I figured out that installing anaconda (conda install anaconda) just linked to the existing packages and didn't leave anything for the pip installer to do. But w/o installing anaconda (conda install -n py37 python=3.7) plus the subsequent pip installs all the packages (incl. vs2015_runtime) got newly downloaded and afterwards my Python visual worked like a charm. Thanks for your help, guys!

Re: Python Integration Error

Anonymous — Mon, 15 Jul 2019 12:50:34 GMT

great solution, I fixed the ImportError based on your suggested solution. Thank you very much

@Anonymous wrote:
@Anonymous ,

Do you know what version of Python your Anaconda environment is using? I was running into issues importing packages with 3.6 and 3.7.

I was able to get around the error by creating a new conda env with Python 3.5:
conda create -n py35 anaconda python=3.5
Then pip installing relevant packages (I had issues with PowerBI recognizing conda installs):
conda activate py35
pip install matplotlib
pip install pandas
After this is complete, you need to point PowerBI to the new env.

Including steps for those less familiar:
File -> Options and Settings -> Options -> Python Scripting

Then add the Path to your new Env. Mine looks like:
"C:\ProgramData\Anaconda3\envs\py35"

This thread tipped me off to the issue:
https://developercommunity.visualstudio.com/content/problem/362404/importerrordll-load-failed-the-specified-module-co.html

Let me know if you have questions.

Re: Python Integration Error

AMM — Mon, 15 Jul 2019 21:32:52 GMT

I too am encountering this error.

I chose to intall Anaconda and this resulted in Python version 3.7.3 being installed. I have verified using the command line and Jupyter notebooks that python, numpy, pandas, matplotlib and even seaborn work. I tried upgrading python using conda. I also tried creating a new enviroment version 3.7.1 which is supposedly the supported Python version. That too did not work, I could not navigate to the environment veriable from inside Power BI but I could change to that environment using the command line.

I tried replying earlier but now that I have created an account I can post a screen shot showing my inability to navigate to the Anaconda environment.

I may need to get someone with administrator privlidges or completly blow away Anaconda but I was able to install Anaconda without administrator privlidges.

Re: Python Integration Error

bclrk — Mon, 16 Sep 2019 14:53:32 GMT

I was able to fix this issue by using pip to uninstall matplotlib and pillow and then reinstall them. That is:

pip uninstall matplotlib
pip uninstall pillow
pip uninstall numpy
pip install matplotlib
pip install pillow
pip install numpy

Re: Python Integration Error

AMM — Mon, 16 Sep 2019 14:31:36 GMT

I of course tried this then tried to create a python visualization or at least print("Hello") and I got the following error:

ImportError: DLL load failed: The specified module could not be found.

The default imports seem to be: os, uuid, matplotlib

Then later numpy as np

I'll submit another frown, but to say it didn't just work would be an understatement. I did test that I could use matplotlib, numpy, pandas etc. in Jupyter notebook even seaborn.

I ran your suggested installs and uninstalls in the order you suggested from the command line built into JupyterLab FWIW.

Cheers,

Re: Python Integration Error

bclrk — Mon, 16 Sep 2019 14:54:44 GMT

You may have already tried this but a pip uninstall and install of numpy and any other packages in the error could help.

Re: Python Integration Error

AMM — Mon, 16 Sep 2019 15:08:15 GMT

Of course I tried reinstalling months ago, but I did it again. Seaborn still does not work maybe I should use pip on that but I persisted with some test code as I got a different error after reinstalling numpy. I didn't use any PowerBI integration but I was able to use this code:

from matplotlib import pyplot as plt
import numpy as np
def sinplot(flip = 1):
   x = np.linspace(0, 14, 100)
   for i in range(1, 5):
      plt.plot(x, np.sin(x + i * .5) * (7 - i) * flip)

sinplot()
plt.show()

To get below so thanks, but

Re: Python Integration Error

barakb32 — Sun, 17 Nov 2019 10:04:27 GMT

Hi @Anonymous ,

Your solution did the job for me.

However I had to have an extra step: copying the environemnt folder from the C:\Program Files to another location, since the Python Script options in Power BI Desktop doesn't allow browsing to the C:\Program Files (probably IT policy).

Do you know how to configure the path in which the new env will be created within conda create?

Thanks,

Barak

Re: Python Integration Error

barakb32 — Sun, 17 Nov 2019 10:32:02 GMT

@AMM

I ran into the same but manged to find a solution:

1. In your Windows Explorer search for afolder named Continuum. Within this folder you will find /anaconda3/envs. If that doesn't work try:

a. Copy the current path of Pyrthon Home Directory and paste in your Windows Explorer

b. Browse up to the anaconda3 folder

c. Browse down to /envs folder

2. Copy the py35 folder (subfolder in /Continuum/anaconda3/envs) to a location that you can browse to from Power BI Desktop

Barak

Re: Python Integration Error

Echicken07 — Fri, 16 Jul 2021 02:13:35 GMT

I've been at this for 3 days and couldn't figure it out.

Kept getting the same error messages as the following cases:

1. https://community.powerbi.com/t5/Desktop/Microsoft-PowerBI-Scripting-Python-Exceptions/td-p/850714

2. https://community.powerbi.com/t5/Desktop/Power-BI-Python-with-Anaconda-missing-dependency/td-p/665102

It wasn't until I ran the following uninstall and reinstall scripts in CMD that it FINALLY worked!! You are a life saver. Thank you so much.

Re: Python Integration Error

Anonymous — Mon, 27 Sep 2021 12:36:51 GMT

Thank you! 🙂👍🏾

Re: Python Integration Error

kgarayev — Mon, 20 Dec 2021 05:20:17 GMT

Excellent! Thank you very much

Re: Python Integration Error

mficco — Fri, 31 Dec 2021 15:21:51 GMT

This worked for me! Thanks!

Re: Python Integration Error

Anonymous — Sun, 23 Jan 2022 01:31:23 GMT

Thank you!

Re: Python Integration Error

nlashakhoori — Sun, 01 Jan 2023 11:37:52 GMT

I am new to python, where shall i run this code ?

Re: Python Integration Error

AMM — Tue, 03 Jan 2023 15:33:36 GMT

It has been a while since I installed Python, I'll have to update it to start the year, but I believe you run pip at the command prompt, it would be the shell in Unix/Mac OS X, but I think in Windows you run it from the command prompt or perhaps from Anaconda Prompt. I was suprised to start the new year with a question from this old thread. Many Power BI updates have come out since this fix.