Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |