Scrape Data from Multiple Web Pages with Power Query

[robertbartlett]

That is absolutely brilliant!!! I have spent the last two days trying to figure out how the do it in Python and within 8 minutes you showed me a much easier straight forward way.

[prameelar]

I watched this video on this teachers day, and I believe you are one of the best teacher could help me on web scraping... 🤗

[obinnaduru]

Thank you so much for this video. Very practical for my Data Analyts journey. I followed the steps and didn't tun into any errors.

[abdulhaseeb]

It's like you have read my mind because I was looking to scrape data from web like this currently. Thanks for the tutorial it's really helpful.

[fentian]

Wow, what an astonishing concept and how wonderfully well you've explained it.

I've just applied it in Excel PQ to call an API over and over with a number of variables including a date that changes for each iteration, returning JSON data that is then transformed and presented in a pivot table. Thank you Mynda, xxx

[davegoodo]

A bit beyond me at this point Mynda, Power Query is on my "to learn" list. Well presented.

[geoffreyzziwambazza]

To think I was doing this manually 🤦🏽‍♂️. Thank you, this is a huge time saver!

[Secret구이구이]

Thank you!
It is hard to study in Korea because there is not much data about powerquery.
Thanks to this, I integrated several post api into a single query.

[awesh]

Thanks Mynda, there is no way that I would not like this video. It's awesome.

[jamessawyer]

I wasn't even aware that M/Power Query can be used to such extent. Thank you for the great insight!

[davidstevens]

Wow...Easily used this tutorial to query printer settings from every Zebra printer on my LAN. Very helpful!

[kaimay]

Anyone know if HasData can be integrated with Power Query to scrape sites with changing content? Seems like it would help automate even more.

[awesh]

This is an amazing way of working with web pages. I have seen people write lengthy macros and Python code for this.

[markhooper]

That's remarkable; this is like the limit of most peoples Python learning, and most co-workers would consider them "dangerous" with those Python abilities. (in the most professional and excellent way of course!)

[malaniebanney]

I slightly adjusted this to scrape data from a folder full of PDF files. Excellent thanks!

[sushicatsan]

I knew this was possible, but ran into some errors while trying to do it on my own. Thank you very much for the great tutorial. Now to let Power Bi Spin!

[biswajeetswaro]

Great video mam!!! I was doing this before python then saved into csv then importing to PBI. Now I can do with PBI directly 👏👏👏

[MichaelHendersonMHC]

Brilliantly framed and well communicated. Thank you again Mynda.

[LeonoraRolston]

This is fantastic! Had no idea it could be done. Explained so well - thanks!

[StephanOnisick]

Awesome use of M for us tiptoeing into the M Script!