Forum Discussion
Error when connecting python to PBI
Unable to connect:
Details: "ADO.NET: Python script error.
Traceback (most recent call last):
File "PythonScriptWrapper.PY", line 2, in <module>
import os, pandas, matplotlib.pyplot
File "C:\USERS\WAA302\APPDATA\LOCAL\CONTINUUM\ANACONDA3_5.3.1\lib\site-packages\pandas\__init__.py", line 19, in <module>
"Missing required dependencies {0}".format(missing_dependencies))
ImportError: Missing required dependencies ['numpy']
"
Can anyone help please?17 Replies
With the November 2019 release of PBIDesktop I see no issues running Python 3.7 from the Anaconda stack. All that is needed is to start PBIDesktop from within an activated conda environment and have the Python home directory configured in the Python scripting options.
From the Anaconda Prompt run:
(base) C:> "Program Files\Microsoft Power BI Desktop\bin\PBIDesktop.exe"pkoetzing I don't appear to have this option. I'm running Windows 10 Pro, and I just installed PBI Desktop as an App, so it doesn't seem to show up in any of my folders as a file. Is there a way to get around this regardless?
Windows 10 Apps are stored in C:\Program Files\WindowsApps, so you can find the executable in something like
C:\Program Files\WindowsApps\Microsoft.MicrosoftPowerBIDesktop_2.75.5653.0_x64__8wekyb3d8bbwe\bin\PBIDesktop.exe
However, the WindowsApps folder is both hidden and protected, but with admin rights you can take over ownership like described e.g. in this article: https://www.maketecheasier.com/access-windowsapps-folder-windows-10/.
It woked doing this way . Thank you very much
From what I am seeing in your error message, it looks like you are missing a Python package "numpy".
is you PATH environment match what you have in your options?
to check your environement:
1) Open the Python Shell and
2) type:
import sys
print(sys.exec_prefix)
