Python Script in Power BI

[kennethsingh]

It's great that Power BI already has the capability to run R scripts for data transformation. It would be even better if we could run Python script.

[julio_guzman]

Just like the desktop edition allows you to run an R script to generate data frames that can then be used for data visualization or any other activities within Power BI, let's do the same for Python via the use of python libraries like pandas, numpy, etc.

[curtis_pokrant]

Python would play role of backend data acquisition, transformation and Power BI doing some visualization and distribution of results via Power BI Online. Power BI API can be used to move Python data to Power BI Online. I have not yet seen any Power BI API Python examples yet. However Power BI API requires Azure Active Directory oAuth authentication. This could be initiated by the Python code, that would push Python results to Power BI datasource, and Power BI report would refresh off that data.

[vineeth_babu]

My organisation uses python for optimization and predictive analytics, currently the exclusion of python from Power BI/desktop is a big drawback. This might also prevent seasoned / budding data scientists from exploring power BI. Please integrate the support for python scripts and visualizations to power BI.

[jperez5]

We need Python in Power BI! During the Microsoft Data Science Course you are allowed to choose R or Python. It make sense for Power BI to allow both...

[barry_martin]

Python is an excellent choice for analytics. I hope there is a way to include this in future versions.

[j13figueroa1]

Im running in the data science professional degree from edx and chose python, I will like to see this option. Actually i'm staring to use power bi in my agency because each of us have a 365 business licence so i hope to use my python skills on this.

[julio_guzman]

Any hopes of this happening?

[ebristow]

If this could add a connection to SPSS's .sav files, I would be all for it.

[daniel_voisey]

I use python with pandas, numpy and other libraries to transform data and produce output tables which I then display using power bi because the power bi graphics are so cool. But I think python rocks for data cleaning and transformation. So if ms were to support python more in power bi to make the above workflow smoother then that would be cool.

[julio_guzman]

Just a follow-up...anything new here?