chass's avatar
chass
Icon for Impactful Individual rankImpactful Individual
6 years ago

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

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

 

 

 

7 Replies

  • chass's avatar
    chass
    Icon for Impactful Individual rankImpactful Individual

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

     

    • chass's avatar
      chass
      Icon for Impactful Individual rankImpactful Individual

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

  • Anonymous's avatar
    Anonymous
    Not applicable

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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?

  • Icad01's avatar
    Icad01
    Icon for Kudo Collector rankKudo Collector

    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

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