St. Louis SQL Server User Group

Welcome to the St. Louis SQL Server User Group (STLSSUG)   

Join Our Group Online!

PASS Summit 2019 Seattle, WA November 6-8
Use code LGDIS7RW6 to receive a $150 discount off your PASS Summit 2019 registration



Next Meeting




STLSSUG & BI July 10, 2018 - Using Power Query M to Scrape The Web

  • In-Person @ 3 City Place Drive, 11th Floor, Room #2 St. Louis, Missouri, United States (map)
  • 18:00 - 19:30 Central Daylight Time
  • Language: English

St. Louis SQL Server & BI User Group Meeting

July 10th 5:45 pm- 7:30 pm



Register online to be included in the lunch count at:



Daugherty Business Solutions (

3 City Place Drive, 11th Floor

Creve Coeur, MO 63141


Sponsor & Host: Daugherty Business Solutions (


5:45 – 6:00 pm         Registration - Dinner
6:00 – 6:05 pm         Welcome, PASS News
6:05 pm – 7:15 pm   “Using Power Query M to Scrape The Web”, Alex Powers
7:15 pm – 7:30 pm   Evaluations and Raffle Drawing


Abstract - Using Power Query M to Scrape The Web

The process of monitoring-exporting-cleansing-importing online information is now a thing of the past using Microsoft's Power Query M formula language (Power BI, Excel). In this presentation you will learn how to leverage the GUI in combination with the Advanced Editor, write your own custom functions, navigate the HTML Document Object Model and manage recursive events using online information. A basic understanding of programming is recommended though not required, internet access is required for those who wish to follow along.


About Alex Powers

From financial services to felines, the World Wide Web to wrestling - Alex Powers has an affinity for the conventional and unconventional when it comes to transforming information. A self-proclaimed Excel Enthusiast Alex Powers enjoys contributing to online forums, writing blog posts ( and sharing his passion for empowering others using Microsoft Excel and Power BI.


Join us online

Join Skype Meeting       Trouble Joining? Try Skype Web App




Back to Top