Connecting to the Web

In this section, we'll practice connecting to websites. We can only retrieve data from web pages that contain tabular data. A key advantage of this approach is that if the data on the webpage is periodically updated, the data in Power Query will automatically update as well.

We'll practice extracting a table from this web resource:

If you need a step-by-step guide, here’s a e-book for you.