Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Python Integration Error

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 err...
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.

 

  • AMM's avatar
    AMM
    Frequent Visitor
    7 years ago

    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. 

    • barakb32's avatar
      barakb32
      Advocate I
      6 years ago

      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