Service Dogs in the Cabin - Web Scraping Puppy Data with Microsoft Fabric - 1st Leg
summary
Shows a working pipeline that scrapes the International Guide Dog Federation website and maps affiliate offices into a Power BI report using Microsoft Fabric components: Power Query / M in Dataflows Gen2 and PySpark notebooks. Uses CSS selectors (nth-child, row selectors), Chromium inspect and mentions Selector Gadget to locate divs and list-item paths, then builds an HTML-to-table extractor. Demo hits timing and fidelity issues but delivers M code, selector strings and a Power BI report prototype that mostly works; slides and GitHub code follow up.
AI-written summary · about
chapters (9)
- 0:00Web scraping with Microsoft Fabric
- 1:53Flight plan and goals
- 3:38CSS selectors for scraping
- 6:27Live demo: CSS selectors in HTML
- 10:07Scraping table data with CSS
- 14:47Inspecting elements in Chrome
- 17:21Power BI with scraped data
- 19:56Selector Gadget tool overview
- 20:40Q&A
related talks
49mBuilding an NFL Scouting Dashboard with Azure Data Services
42mScraping Your Way to a Dataset
30mDataEngBytes 2023 - BRI-T1-04 - Mimoune Djouallah
40mPuppies or Muffins
01h 03mFeed Your Data! OData Data Feeds for PowerPivot Users
50mFabric: What's new and what's next
38mScraping LEGO for Fun: A Hacky Dive into Dynamic Data Extraction
45mPython tools for webscraping