Scott Stauffer

Sometimes you need to source data from the internet, but there isn't an API to access partner, industry or public data available out on the web... and that's when you need to roll up your sleeves and get your hands dirty. In this session we'll start out with "Get Data" in Power BI with a little bit of "Add Table Using Example" and move quickly into the Power Query Advanced Editor and explore the M code that is the magic of the Html.Table function. This is where we must put our Web Dev hat on for a bit while we explore the Document Object Model. Then we take things to the next level with some Python libraries to solve some of the bigger challenges. This Session would be mostly demos and conversation with the audience. Slides to support resources used and key points.

Let's explore CSS Selectors so that we can do some web scraping in Power Query with Power BI, m code in Dataflows Gen 2, and PySpark Notebooks - All in the Azure cloud within Microsoft Fabric.

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.