Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Power BI Python with Anaconda missing dependency

Hi,   I'm trying to use my Python script in Power BI, however I'm faced with this error message when trying to run it:    Details: "ADO.NET: Python script error. Traceback (most recent call last)...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    The Python environment I'm referring to already has the required dependencies installed. I was suspecting the error to be caused by the activate.bat file not activating the Python environment in Anaconda, prior to running the script. However, I managed to resolve my problem simply by updating Python in Anaconda Prompt i.e. 

    conda upgrade python
TimoRiikonen's avatar
TimoRiikonen
Advocate V
6 years ago

WinPython solution with a minor edit.

Step by step procedure: 

  1. Download last version of Winpython from : https://winpython.github.io/
  2. Install Winpython on C: \
  3. In Power BI Desktop, select File > Options and settings > Options > Global > Python scripting. Set

    Python home directory as something like C:\WPy64-3770\python-3.7.7.amd64

  4. Optional: Restart Power BI

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Timo, 

I tried to set it up with the home directory at C:[...]\WPy64-3940\python-3.9.4.amd64 but got a note saying that this is an invalid path. Any ideas? 

In general and just because I'm new to this, what's the appropriate way to get Power BI able to run Python scripts (eg the one here). 

All necessary packages/libraries (pandas, numpy, matplotlib) are installed however, I am still unable to work with it. 

Any help would be really appreciated! 

Kostas