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
stephank's avatar
stephank
Frequent Visitor
6 years ago

 can you please refere to a step-by-set setup. It seems using python directory and IDE anaconda's python exe file

 

I cannot get it run with a demo script 

  • mjeh's avatar
    mjeh
    Frequent Visitor
    6 years ago

    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 > Python scripting. The Python script options page appears. 
    4. Specify the local Python installation path with the Winpython folder defined at step 2
    5. Restart Power BI
    • 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

    • stephank's avatar
      stephank
      Frequent Visitor
      6 years ago

      wow, that really worked. thank you so much

       

      Stephan