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

wow, that really worked. thank you so much

 

Stephan