Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Re: Retrieving YouTube Video Views and using web pages as data sources for Power BI Reports

11-29-2021 16:52 PM

chass
Impactful Individual
2240 Views
chass
Impactful Individual
Impactful Individual

Retrieving YouTube Video Views and using web pages as data sources for Power BI Reports

‎07-25-2020 05:45 PM

Starting with Reza's great article "Get Started with Power Query: Movies Data Mash-Up" and some encouragement pulled together a report that retrieves all the community videos from the Power Apps community site and then retrieves information about those videos including the community creator name YouTube URL and YouTube views. 

If you haven't used the M language to retrieve Web data I highly encourage you to download Reza's Power BI: Power BI online book: from Rookie to Rockstar, that covers this topic indepth in a couple of sections including the section:  Get Images from Web Page Into the Power BI Report Using Power Query

 

 

 

Chuck Sterling
Message 1 of 8
3,116 Views
sujatakaran
Helper I
Helper I

‎02-18-2022 02:48 AM

I can not see the dashbord, its not available. Can you please share pbix file?

Message 8 of 8
1,933 Views
0
Icad01
Kudo Collector
Kudo Collector

‎12-01-2021 12:53 AM

Hey Chuck @chass,
Thanks for your good work 🙂

It's very useful for learning Power Apps.

A few suggestions to make it even more useful, IMHO:

1- Add a "Search text" visual for the video name.

2- Add the "Search" and "Select All" options in the Author's slicer.

3- Add a "Text Cloud" visual to highlight video names keywords.

4- Keep it a one-screen report (No vertical scrollbars. Use a smaller font if needed), if possible.
Thanks again.

Arie

Message 7 of 8
2,160 Views
0
Anonymous
Not applicable

‎11-30-2021 06:41 AM

Right, I have tried scraping the number of views and likes from Youtube using this approach but it seems like the Power BI scraper doesn't find CSS frames for those. Is there any chance I can take a look inside your M code to understand how you extracted likes and views?

Message 6 of 8
2,200 Views
0
Anonymous
Not applicable

‎11-29-2021 09:06 AM

Very impressive! How did you extract Youtube data into Power BI? Was it through scraping functionality inside Power BI or did you use Python?

Message 4 of 8
2,256 Views
0
chass
Impactful Individual
Impactful Individual
In response to Anonymous

‎11-29-2021 04:52 PM

Yes it was done through M language and web scraping.  Reza walks through how to do this here:  "Get Started with Power Query: Movies Data Mash-Up" 

 

Chuck Sterling
Message 5 of 8
2,240 Views
0
chass
Impactful Individual
Impactful Individual

‎07-25-2020 05:59 PM

Word of warning: Each row is retrieving data from YouTube and the Power Apps community by traversing all the HTML so it takes about ~20 seconds a row.  There are about 800 community videos in the Power Apps community so it takes a long time time apply all the changes (about 4 hours). 

 

Chuck Sterling
Message 2 of 8
3,067 Views
0
chass
Impactful Individual
Impactful Individual
In response to chass

‎08-05-2020 09:26 AM

8/5 V2 Now has date slicer to show videos by date

Chuck Sterling
Message 3 of 8
2,801 Views
0