SQLBits 2024

Service Dogs in the Cabin - Web Scraping Puppy Data with Microsoft Fabric - 2nd Leg

Let's take what we learned about CSS Selectors in the previous so that we can do some web scraping in Power Query, m code, and PySpark - All in the Azure cloud within Microsoft Fabric.
In this first leg of our two-leg journey, you learned about CSS Selectors. In the second leg of the flight, be prepared to leverage what we have learned from the first leg.
We will start by performing some basic aerial manoeuvres - first with Power Query in Power BI. Next, we will explore the M code that is the magic of the Html.Table function with Dataflows Gen 2. We then go full-on "Snakes in the Plane" with Python libraries in PySpark Notebooks in Microsoft Fabric.