This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. 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
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 4 | |
| 3 |