Python in Power BI Webinar: Navigate the Possibilities

Подписаться 4,3 тыс.

Просмотров 53 тыс.

50% 1

Join David as he explores the possibilities of Python in Power BI. Learn more about Power BI from BlueGranite here: bit.ly/3liRquT
Python has become one of the fastest growing and increasingly useful languages for data. Whether it’s being used for basic data transformation and visualization or the most advanced machine learning, Python has broad support for a variety of workloads. Taking advantage of that trend, Power BI recently introduced support for Python.
In BlueGranite's recent webinar, you will see several examples of Python in action for data modeling and visualization in Power BI. You will also learn where and how Python fits into a Power BI development workflow. Finally, you will see how to balance Python with native Power BI functionality and determine what limitations must be considered when using Python in Power BI. Check out www.bluegranite.com for more information.
**NOTE: This webinar was recorded when Python was still in Preview in Power BI. It is no longer in Preview.
0:00 - Intro and Overview
6:42 - Why Python in Power BI?
9:03 - Python vs R in Power BI
12:08 - Limitations in Power BI
14:23 - Initial Python Setup
18:18 - Python Script in Power Query
20:20 - Basic Performance Tips and Troubleshooting
27:02 - Common Python Libraries
30:14 - Python Visual (Static Image)
30:50 - Ridge Plot Sample (Seaborn) - Python Visual
34:19 - JointPlot Sample (Seaborn) - Python Visual
37:54 - Geocoding Sample (Azure Maps, Geopandas, GeoPy) - Python Script
43:44 - Text Analytics Sample (TextBlob, NLTK) - Python Script
48:02 - K-means Clustering Sample (scikit-learn) - Python Script
51:47 - Questions
BlueGranite: www.bluegranite.com/
Blog: www.bluegranite.com/blog
Live and Recorded Events: www.bluegranite.com/events
#PowerBI #Python #PyData

Наука

Опубликовано:

11 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 28

@jacksonaquino7024 3 года назад

This is a true power BI guy. Even his deck is in power BI 😄

@elliottharris4526 4 года назад

So grateful this turned up on my feed. Exactly what I was looking for. Thanks.

@3CloudSolutions 4 года назад

Great to hear! Thank you.

@Patiencelad 2 года назад

Excellent and thorough webinar. Thanks very much!

@KTpixels 3 года назад

Thanks a ton for this video.

@kavinyudhitia Год назад

nice demonstration. thanks!!

@cornelbekker3989 4 года назад

Thanks guys, good set of examples.

@3CloudSolutions 4 года назад

Thanks Cornel. Appreciate the feedback.

@johng5295 3 года назад

Thanks in a million. Great stuff.

@3CloudSolutions 3 года назад

Thanks for commenting John. We appreciate the feedback!

@Nazeerul_Hazard 3 года назад

Thanks for this vedio. Especially the performance tips are very much useful

@3CloudSolutions 3 года назад

Great to hear. Thanks for sharing your feedback!

@Arieleyo 3 года назад

What a great webinar. Thanks for sharing!! cheers from Buenos Aires

@3CloudSolutions 3 года назад

Thank you for the feedback Ariel. We appreciate it!

@thomassmith9447 3 года назад

Hi, is it possible to deploy pre-built models (e.g. pickled sklearn objects) to make predictions in power BI and display the results?

@jimmyrico5364 3 года назад

This is great, thanks for sharing! Just one question, in the Power BI documentation says that to run Python on any dataset it has to be set as public which is sensitive if the data you’re using is private and company owned, any advice to overcome this challenge please? Appreciate any guidance and keep up the great work!

@3CloudSolutions 2 года назад

Hi Jimmy, please see this response from our consultant: Python scripts being public is needed for the PowerBI service to run them properly (in the limitations section of the second document linked below). docs.microsoft.com/en-us/power-bi/enterprise/desktop-privacy-levels docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-in-query-editor

@jonabaroa770 3 года назад

thaks

@nitinrungta3320 3 года назад

hi, but can we add parameters in Python Script using Advanced Editor?

@santoshadhikari9933 Год назад

How to use python script to loop through slicers data to export multiple report in pdf format/

@mctog1 2 года назад

Hi David, I am late to the show here and a relative beginner with Python and Power BI. Up to this point I have been using Jupyter to call and run a system simulation that's created in another platform. And I am using Jupyter to extract the output data I need from that simulation and output it as a csv file. I then manually import the csv into Power BI to create data visualizations. The functionality of Python Scripting in Power BI that you are showing especially around the 31:28 minute mark suggests to me that I can skip my intermediate steps inside Jupyter altogether. Those scripts I was running in Jupyter could be simply run directly inside Power BI. Am I understanding that correctly? Thanks for your time.

@dylanleung7559 2 года назад

I am also wondering this too. Did skipping the execution in Jupyter all together work for you?

@thealchemist6133 2 года назад

can I get a copy of the PBIX file with the python script?

@sawankumar2088 3 года назад

Nice Video Can we use Python scripts in Power BI service online

@3CloudSolutions 3 года назад

You can’t write them in Service, but you can refresh a dataset that uses them. It requires the *personal* Gateway to do so though rather than the primary gateway mode.

@sawankumar2088 3 года назад

@@3CloudSolutions what is gateway

@kaveharshadi8127 2 года назад

Hi, and thank you very much. Can i do that just with DAX in power BI ?

@3CloudSolutions 2 года назад

Hi Kaveh, please see this response from one of our consultants: DAX serves a very different use case and comes in to enhance an already available PowerBI data model through creation of measures, calculated columns, and custom queries and tables. Much of the uses of DAX comes after the fact you've determined your tables, and key numbers and KPIs. The main goal of the presentation is to cater to developers who use common open source tools like R or Python to interface with PowerBI effectively (either through custom visuals or cleaning up data and building a data model versus using Power Query/M). You couldn't substitute Python in the script editor unless the table was already created and available for DAX. You could probably replicate the machine learning abilities Python uses in DAX, though it may be much harder to do and Python already has pre-built packages in scikitlearn to do that already and is likely easier to do. You could also leverage DAX to create tables that can be used to create visuals.