Learn Excel – Scrape Webpages Using Power Query – Podcast 2056

Write one query to load one web page. Then, turn that query into a function and use Power Query to load many web pages. Today’s trick is adapted from the M is for Data Monkey book Build a query to get data from one web page Edit the query to change it into a function […]

34 students enrolled

Write one query to load one web page. Then, turn that query into a function and use Power Query to load many web pages.
Today’s trick is adapted from the M is for Data Monkey book
Build a query to get data from one web page
Edit the query to change it into a function with VariableName before Let
Change the hard-coded URL to VariableName
Rename the query to fxWeather
Close & Load. The data will disappear.
Use Excel Trickery to create a table of all URL’s
Create a query from that table.
Add a new column of Weather = fxWeather
Expand the column. Uncheck Prefix
Amazing!

Be the first to add a review.

Please, login to leave a review
Learn Excel – Scrape Webpages Using Power Query – Podcast 2056
Get course
30-Day Money-Back Guarantee

Includes

Full lifetime access
Access on mobile and TV

Categories

Archive

Working hours

Monday 9:30 am - 6.00 pm
Tuesday 9:30 am - 6.00 pm
Wednesday 9:30 am - 6.00 pm
Thursday 9:30 am - 6.00 pm
Friday 9:30 am - 5.00 pm
Saturday Closed
Sunday Closed
Learn Excel – Scrape Webpages Using Power Query – Podcast 2056
Price:
Membership
This website uses cookies and asks your personal data to enhance your browsing experience.