Connect Python with PowerBi

[tgmiller5]

Does anyone have steps on how to connect Python with PowerBI? Is API the only way to go?

[Waa302]

Hi, Despite the fact that I do have Python installed when I'm trying to connect it to PBI I get an error message:

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']
"

Cann anybody advise please?

Thanks 

[v-yuezhe-msft · Accepted solution]

@tgmiller5,

With Power BI Desktop August version, you are able to  use Python to do data cleaning, analysis, and visualization. For more details, please take a look at the following blog.

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2018-feature-summary/#python

Regards,
Lydia