Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
Does anyone have steps on how to connect Python with PowerBI? Is API the only way to go?
Solved! Go to 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
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
@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
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.