Pull data from almost any website, even when it looks impossible!
from the web?
Like this...
Manually selecting, copying and pasting is a time sink, it’s mind-numbingly repetitive, and honestly, it’s just not sustainable.
What if new data gets added to the site? Your process breaks, and you’re back to square one. 
It’s time to let go of repetitive work and start using Power Query’s web scraping capabilities.
sooo much time
Using Power Query you’ll be able to…
Automate manual copy-pasting
Tackle complex Web Structure
Expand your Analysis
Power Query makes web scraping highly accessible to a business user.
In this course, you’ll learn robust techniques to build queries and even troubleshoot them. We’ll start simple and gradually dive into more advanced methods step by step.
Section 1 - Getting Started with Web Data
Section 2 - Scraping Nested Data
Section 3 - Pagination: Getting Data from Multiple Pages Automatically
Section 4 - Using APIs to Scrap Data
Section 5 - Post Request & Authorization with Request Headers
Section 6 - Functions
I’m excited to have Bhavya Gupta guide you through this course on mastering web data with Power Query. Bhavya is a true expert in the Power Query space and has a real talent for making complex topics easy to understand. He’s spent a lot of time figuring out the best ways to get data from the web, even from tricky websites. You might know him from his “Power Query YT” channel, where he shares tons of valuable insights. With Bhavya’s practical experience and clear teaching, you’re in great hands to learn how to automate your web data collection and unlock new possibilities in your reporting. 
I’m excited to have Bhavya Gupta guide you through this course on mastering web data with Power Query. Bhavya is a true expert in the Power Query space and has a real talent for making complex topics easy to understand. He’s spent a lot of time figuring out the best ways to get data from the web, even from tricky websites. You might know him from his “Power Query YT” channel, where he shares tons of valuable insights. With Bhavya’s practical experience and clear teaching, you’re in great hands to learn how to automate your web data collection and unlock new possibilities in your reporting.
Bhavya’s Simple & Practical Teaching Style
I highly recommend Bhavya, he’s a brilliant instructor!
Bhavya’s Simple & Practical Teaching Style
I highly recommend Bhavya, he’s a brilliant instructor!
What if I'm completely new to Power Query?
You’ll need a basic understanding of Power Query to follow along. If you’ve used it before to clean or transform data, you’re good to go. This course builds on that and shows you how to handle web data specifically.
Do I need to know coding to take this course?
Nope. You’ll write a bit of M code here and there, but everything is explained step by step. You don’t need a coding background, just a willingness to learn.
Will this work for any website?
Not every single website, but a lot more than you’d expect. You’ll learn how to handle many tricky layouts, paginated pages, and even data hidden behind forms and post requests.
How long will I have access to the course?
If you purchase the course only, you’ll have 3 years of access. If you join the Goodly Insider community, you’ll have 1 year of access to this course and the other courses listed in the pricing table, and you’ll need to renew your Goodly Insider membership each year to keep your course access active.
What if I get stuck or need help?
You can always reach out with your questions. We’ve also included exercises and solutions so you can practise and troubleshoot as you learn.
Do I get a certificate after completing the course?
Yes, you’ll receive a certificate of completion once you finish the course.
Web Scraping using Power Query?
$147 199
$499 969
₹9,990 12,990
₹29,990 45,949
© [2025] Web Scraping in Power Query. All rights reserved.