I’ll try to find the link, but Power BI doesn’t play nice with Anaconda. I installed WinPython (https://winpython.github.io) instead, and have had no problems with Power BI and python since.
As the initial questioner assumed the problem here is the missing activation of the conda environment. This can be done by running the activation script like
where py37 is a Python 3.7 environment. This adds the following folders to the PATH:
Anaconda3envspy37 Anaconda3envspy37Librarymingw-w64bin Anaconda3envspy37Libraryusrbin Anaconda3envspy37Librarybin Anaconda3envspy37Scripts Anaconda3envspy37bin
Anaconda3envspy37 is the Python home directory that needs to be added to the PBIDesktop global options in the Python scripting section too. Now all that’s left is to start PBIDesktop from within the activated environment like:
(py37) C:> "Program FilesMicrosoft Power BI DesktopbinPBIDesktop.exe"
If you are not using virtual environments as recommended, at least the base environment needs to be activated.
With the PBIDesktop November 2019 release I see no issues running Python 3.7 from Anaconda.