Running Python Scripts in Power BI

What's up guys, Parker here. In this tutorial, I show you how to run Python scripts to perform transformations on your dataset. Python is an extremely versatile language that can be used for all sorts of data processing and cleaning! Note: as of the date of posting, Python is only available in Desktop. You can expect it to be available in Service soon!

Enroll in my introductory or advanced Power BI courses:

Elite Power BI Consulting:

Data Insights Tools:

Python Download:

[michaniedospia]

Like it, great! I'm using Python at work and lately we are moving to presenting data with Power BI and finally I know to to merge them both!

[markbaich]

Great video. Might want to mention that Python is currently only supported in the PBI Desktop version, not the web service.

[gambu]

Absolutely impressive! I'm actually offended that some found it reasonable to dislike this work of art.

[surajitbaruah]

Nice demo on connecting connecting Python in Power BI.

[Analyse_Us_Consulting]

Great Video. Awesome to see that we aren't limited to the python std library.

[asadrauf]

Hey Parker, there are only a few channels on youtube that make good educational content. Yours is the best for all things related to BI. So, first thanks mate! Now, in this video, you mentioned that you'd be making more python videos (ML for predicting missing values). Is that plan still operational or have you decided not to do that? Either way thank you very much man!

[z]

Brill, lots of learning to the core and insightful.Glad I found this.No waffle.

[Hemantshyontry]

Thanks for the video...it's really good and quite informative. Keep up the valuable work.

[joostvoncken]

nice & fast video, got me started!

[sirginirgin]

Very informative with a simple and easy approach explanation Parker. Kindly can you reply with a link for the ML in PBI video.Thanks

[davida]

Can you use python as a means to import data into Power BI (for instance thought want to web scrape data directly into Power BI or you want to retrieve all file names from a specific folder and create a table based on those file names in Power BI?

[Rahul-wixn]

Hi Parker, nice video. I have one question.I have a power bi data visualization dashboard and i wanted to do automation testing to verify that the data displayed in the dashboard is as expected ? can i use python for the same? if yes, do you have any reference to help me to learn that part ? (Disclaimer: Beginner in Python :) )

[sawankumar]

Thanks Parkar i was searching this kind of videos related to Power BI and Python together
from very Long time.
Parkar have you made more videos of this kind please share the link

[bryanurizar]

Is the python syntax here specific to Power BI or would just learning pandas be enough to then use in Power BI?

[abhishekpachauri]

Hi I am trying to install pandas but it is giving me below- 'py' is not recognised as an internal or external command, operable program or batch file. What should I do?

[xxczerxx]

Is there a discernible advantage/use case for running Python scripts in PBI, versus the standard power query methods? I can't think of many off the top of my head.

[affiliatenetwork]

I've got a problem saving the table changes and am not sure what might be the cause. The error I receive says the following:

"Failed to save modifications to the server. Error returned: 'Expression in partition 'n/a' in table 'n/a' references unknown variable or function 'Python.Execute'.
'."

the only solution I was able to find is to disable the Store datasets using enhanced metadata format, but it did not help. Any ideas what else might be?

[vishalpawashe]

Thanks for this wonderful video. Also, would it be possible to make a video on more features of Python which can be used in Power BI which would relate to the real world projects/uses

[karimfarghaly]

I am working with mac, I run power bi on a virtual machine. To use python with power bi should I install Python for windows? Or it can work ( integration ) with mac os

[luigineri]

Hi, great video. Why didn't you start Power Query (Edit Query) and then you load the data instead of coming back from Power BI to Power Query?