Forum Discussion
Connect Python with PowerBi
Does anyone have steps on how to connect Python with PowerBI? Is API the only way to go?
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
2 Replies
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,
LydiaHi, 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