topic Re: Retrieving YouTube Video Views and using web pages as data sources for Power BI Reports in Data Stories Gallery

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

chass — Wed, 05 Aug 2020 16:25:24 GMT

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

eyJrIjoiY2IwZWE1YTctNTZjYi00MzViLTg1NWMtNGY1YmI5ZDMwOTBmIiwidCI6IjcyZjk4OGJmLTg2ZjEtNDFhZi05MWFiLTJkN2NkMDExZGI0NyIsImMiOjV9&pageName=ReportSection

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

chass — Sun, 26 Jul 2020 00:59:57 GMT

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).

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

chass — Wed, 05 Aug 2020 16:26:25 GMT

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

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

Anonymous — Mon, 29 Nov 2021 17:06:18 GMT

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

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

chass — Tue, 30 Nov 2021 00:52:32 GMT

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"

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

Anonymous — Tue, 30 Nov 2021 14:41:27 GMT

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?

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

Icad01 — Wed, 01 Dec 2021 08:53:33 GMT

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

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

sujatakaran — Fri, 18 Feb 2022 10:48:19 GMT

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