I've been using Python for years and I'm totally new to Power BI, I don't think I can do what I wanted in Power BI, but I watched the whole of the video anyway because it's such a well done video! Also, as Python-fan, watching your enthusiasm made the video even better

Wow...!!! How simple to implement Python you just showed here! Congrats and thank you for sharing! Aside from that, I liked the way you edited your video; audio, zooms, highlighting, story flow... just amazing!

I HAVE NEVER SEEN SOMEONE WITH SO MUCH ENERGY TEACHING !!!!

The video in 6:11 set "matplotlib.pyplot as lib" and launch "pit.show". That's an error. The right code is: (after install pandas and anaconda) import seaborn as sns import matplotlib.pyplot as pit sns.swarmplot(x="day", y="total_bill", data=dataset) pit.show()

Thank you, Patrick! I'm toying with the idea of starting with Python, and I love Power BI, hence I need to mix them. You rock!

probably the best tutorial on youtube ive ever seen, awesome job

That's how you really teach something, rigth in the moment you are learning it yourself. Thanks

Patrick thank you for this. Just yesterday I wanted to use Python in Power BI but had no idea where to start.

I love the R and Python integration in power query but, for me, the personal gateway is the deal breaker. We have an enterprise gateway but that doesn't work. I could install the personal gateway on the same machine but now I have two gateways to update and configure.. :( Is it worth stating that the gateway isn't required for the visualisations as along as you use the support packages.

Patrick is a legend.

This was phenomenal, bro u just made my life a lot easier

I know an intermediate level of python, but have never looked into what's supported in Power BI. Seeing Patrick get something built so easily without evening knowing python was exciting as it shows the integration must be pretty well designed. I'm excited to go through and learn the limitations for myself.

Amazing presentation as usual. Thank you, Patrick! Python and R integration is good. However, there are too many limitations for using Python and R scripts in Power BI which Patrick did not mention (vide documentation). When we want to get data from a data source that is directly not supported in Power BI (quite rare nowadays!), an R/Python script may help. I remember Adam had a video on creating data connectors with C# as well (long time ago). We can do certain transformations that are beyond the capacity of M using R/Python scripting. What we need is a scripting language for Power BI that is comparable to VBA in Excel, a language that is truly incorporated, not superficially attached. R and Python script support in Power BI is still just sensational than truly useful. Let’s see how it develops in the due course. Definitely Interesting, but I doubt if it would be equally useful. Of course, it’s only my opinion as a user of Power BI. There are experts on the subject who think otherwise.

Python for REGEX to validate data quality of a database and then Power Automate to email the users inpuiting bad quality data so they can fix.

This video was excellent and allowed me to get started with Python in my Power BI report.

Hello patrick, I from Nicaragua and don't speak english but this video have subtitle in spanish, so great .. thank you for that could you continue placing the subtitles?

The integration between Power BI and R/Python is amazing for loading and processing data. I've created an automatic data workflow that creates tidy data files stored in the pickle format which I then import and use for visualizing the data. Some reports require further modifications to the already processed data and for those I've set things up so that Power BI calls the execution of a Python script stored in a custom folder that then does the additional data processing. Pretty neat! The exact same thing works with R, too.

Great video. Just starting to explore using Python with Power BI. Interesting to see how the performance of the python queries stack up against DAX.

Python visuals are very slow once the report is published, to slow to be actually used in a report. To my understanding, this is because the script has to be sent back to an azure host that recalculates the visual each time you change it. I try avoiding python visuals in power bi for this reason

Just a friendly heads up: If you add python to your environment variables at the end of the installation (or the beginning depending on which version of Python you install), you can invoke pip without pointing to the directory. 😃

I use a lot R and Python in Power BI but the problem is not being able to take an input from the user and apply it to a model and then give back an output as (chart, table, list etc.) if it would possible to send information to Python and R it would be a big big game change especially to use NLP capabilities from both of languages.

Really looking forward to receive some more important lessons on Python in Power BI.

Nice, thanks for this video ! Hope to have more video about Python integration in Power Bi in future videos

Just out of curiosity, how long did it take you to figure all this stuff out? 🙂 Great to see the "masters" struggle a bit, which is an inevitable part of the learning curve. Thanks for this Patrick!

Yup. Have used Python to extract data from Oracle ERP Cloud to use with Power BI. Never did the visualization though, so that was good to see. 👍

Interaction is a problem with python. Some other visualisation tool has much better integration. Python is great but for visual we can't do interaction from python visual to other part of report

Perfect starter video for a total amateur like me! Thanks Patrick

I've already use Python integration for some of my freelance work and it's great!

This guy's are amazing why Microsoft not seen this channel .

Awesome Patrick ;) I was thinking to test python in PBI since a while. This video made me started... I though it would be a bit complicated, but I am astonished by the simplicity to implement it. Time invested versus the quality and powerfulness of charts. It is definitely worth it. And using data=dataset ... BAM we get the interactivity between charts... For the moment I do not use any service so no issue with the Gateway... I feel I will find out some great usage of python in PBI ;) Patrick you are amazing ! Merci

Please more Video like this, always amazing videos.

Thank you for this Patrick, I am actually starting with learning python. Great video you have right there!

As a python user myself I cringed at your code but was excited to see python work. Great work

Hey Patrick, not sure if this is mentioned but in the command line you dont have to put the full directory of python, just "python -m pip install.." is good enough

Loved this!! Watching him alias matplotlib as lib was quite funny though 😂

I need help, when I try to show it with pit.show() appears this: ;NameError: name 'pit' is not defined

Awesome, thanks for taking the time to do this!

Good "Intro". Makes one eager to learn more about python in Power BI . But more content on top of this is to be expected now. :-)

Liked your video! I am A Python and Power BI Teacher: Very good as a start!

It's weird because I followed your exact steps but I kept getting an error for my columns not being defined... I then got am error for the "pit.show()" not being defined. I tweaked it a bit and this code ended up working for me: # The following code to create a dataframe and remove duplicated rows is always executed and acts as a preamble for your script: #dataset = pandas.DataFrame(day, total_bill) #dataset = dataset.drop_duplicates() # Paste or type your script code here: import seaborn as sns import matplotlib.pyplot as lib sns.swarmplot(data=dataset, x="day", y="total_bill") lib.show()

Great video! Can I ask you what is Personal Gateway? Is it something download and install or subscribe to? Thanks.

A really useful guide.

Another reason to learn python. Thanks.

What do you mean personal gateway? if i share my dashboard with other who doesn't have python install, will they see a error on their side?

Appreciate you posting this info! Very informative and something I was looking for. However, I've been trying to figure out the compelling use case to use python. So far, I can do everything that I've need with OOB connectors, dax and mquery. But, I've seen that doing some development using Python (specifically in Jupyter Notebook) is much quicker because you only deal with a small subset of data instead of loading the entire data set. In some cases, where data load time becomes an issue, i just set parameters to only load recent files or a # of records... Then, let data refresh do the heavy lifting after publishing.

Hello Samuel L Jackson! ) Didn't know you are coding when you are not filming ).

Thanks a lot Patrick! Smooth and very useful orientation! Python and PB! awesome! The best of all the world

Brilliantly explained

bro man bro.....you are legit the most solid doo in the cuooo

Great video. What is a personal gateway??? Also, I am surprised it’s such a short list of supported python packages… I wish plotly was supported for example!

More of the python in power bi please!

We need a full series

Need more videos in python with power Bi

Great stuff man... Would love to see some videos over the GenerateEmbedTokenV2 changes and what new functionality comes with the newer embed token model. Really the main updates with the move to V2.

heyy guy, how can i put it on powerbi services? because it don't work there

Thanks

Patrick can teach you the whole thing about black holes in 5 minutes at your first grade 😁 love that Powerbi support R and Paython but personal gateway is a big no.

Thanks Patrick. This was a good start.

You rock! thanks for the quick demo. I love it

Hoooo, I need to try that! Thanks Patrick

And I was just about to try Python for more advanced analytics in building a dataset. "Only Personal Gateway" is a big showstopper. Makes no sense. Also however cool Python or R visuals, they are just pictures - no tooltip, no interactivity :(

When we work on R and Python visual, it kinda takes lot of load on pbix file. How to optimize the same?

Can you do one for those who have Mac?

Awesome, cool video. Explaining all the details 👍

Slick - Thanks Patrick !!

This was pretty cool!

You could make a video of how to use powerquery and phyton for some data transformation

This is great! I will try this out.

This is great. Its to late that I came here

Thanks.

Do you think this would be effective at defining custom logic for bringing in data? Like having to loop through the dataframe to determine its structure? and returning that dataset? stuff that you cant do just through applying transformations & such...

thanks a lot , where from the data set of "tips" came from ?

Apart from personal gateway to refresh the report, any other way or workaround to do it. Personal gateway is a very big limitation

Thanks. Good intro to the subject!

This is really neat. I was wondering if you could use Python in Power Query at the "source" level to handle folders that have constantly updating information (eg files that have current date in their name)? Does this eat into memory usage or is it still "technically" operating within Python (ie outside M)? I had this problem previously -- a folder on SharePoint that had files being continuously added. I couldn't figure out a way for the Query to update dynamically. So I couldn't figure out a simple logic in M to simply say ("import everything in this folder with string containing 'xxx' "). However, after watching this vid it seems you could simply write a simple Python script to handle that batch import with necessary logic.

thanks for the video

Great demo! Thanks much,

Thanks! Very helpful!

Hey, great video but what if I want to take input from the user and use that in the Python code and give an output how can one do that?

Brother I need a Dax query for the below table - I need a different column in the matrix table Parameters 8 2021 2020 Diff'21-20 Parameters 1 5.63 5.55 0.08 Parameters 2 5.54 - - Parameters 3 5.75 5.62 0.13 Parameters 4 5.51 5.32 0.19

Hello, I got an error when loading the 'tips' dataset. So, In which folder should the tips file be

We need that R video too Patrick

Use of personal gateway... does this mean all users have to have the personal gateway installed to be able to access a published report using python?

This last sentence is quite of a bummer... You need that for any python use, right? I wonder if they'll make changes on that otherwise very limiting

Thank's for this video!

How can I use this with Analysis Services in an emedded app? Thanks!

Q. I just finished a python class, ideally I would be able to some table transformation in python.

Great Video and python skills ;)

When I publish it online, I cannot set up the schedule refresh. Any solution?

Hey Patrick. Neat video. Are the python visuals supported in Power BI service? I noticed you mentioned this only works with a personal Power BI gateway. Doesn't it work with Enterprise gateway? Thanks

Any idea if we can use python in PBI Q&A feature ? I want to enhance the Q&A feature by adding some NLP api's.

Better use pip3 to install other packages. If there is a Python 2 installation somewhere "pip" might download the old version instead of Python 3. Or ensure that pip links to pip3 as it should be.

Amazing, how could you make the blue square move along with your mouse in your video?

This video is awesome and exactly what I needed to introduce me on using Python in Power BI. Does anyone know of any books explaining how to use Python on Power BI?

Wow thank you for the video. Please more :-) Thanks to you this stuff is actually interesting and motivates to do more :-)

You don't need to change path to the source folder for the "pip install". It can be done anywhere :)

Can you include a parameter inside your python script? I'm thinking if you have some code to read a file and clean your data for powerbi, it would be nice to define the file path as a parameter so the user can recycle and reuse your dashboard and code for other files

Hi Patrick! I'm planning to learn power bi right now. can you give me the link from your videos where I can start with? You got tons of videos and I don't know what video to start with. Thanks!

How can I switch parameters for the Python API call script from Power BI user interface.

Would it be an accurate statement to say using Python in PBI is faster than using Power Query M? I'm trying to find this online but haven't really seen anything confirming this and figure I'll ask on my favorite channel. ;)