11-29-2021 16:52 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
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.
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?
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"
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).