Get Data from the Web by Example with Power Query in Power BI

In this video we're going to look at how to scrape data from the web with Power Query in Power BI using the new "Get Data by Example" feature.

Then we'll learn how to copy and paste the data from Power BI into Excel. 👇

Check out my full courses and ebooks here

DOWNLOAD the example workbook here

SUBSCRIBE & get my 3 FREE eBooks

CONNECT with me on social

Thanks for all your support!

[wayneedmondson]

Hi John.. great video and tip.. can think of lots of uses for this feature. It's like Flash Fill on steroids.. haha! Hope it gets into native EXCEL PQ soon. In the mean time, your steps through PBID work perfectly. Thanks and Thumbs up!

[dontown]

That is a nifty new feature! Thanks for video. :)

[midsummer]

Thank you very much - Much appreciated

[antoines.]

Hello How to Excel..this tip is simply magic....Truly...I was able to do it with a webpage...but now I have problems to apply the changes done in the Editor...I have message like "Load blocked by failures with other requests.
" and "page timeout has expired" Would you have an idea and kindly help?? Many thanks again in advance..

[KhalilYasser]

Thanks a lot. Great tutorial.
The videos shows how to grab the first page (50 rows). Is it possible to grab all the pages? Is there a trick to workaround this point to get all the data in all the pages?
Best Regards

[ioanniskiokpas]

Greetings! Useful example as always! :) I am facing some issues with a web page that requires login, while I enter the credentials correctly, it does not seem to connect. Any ideas-workarounds perhaps?

[EyiBillion]

This is Brilliant! Absolute Brilliance. Thank you for this. How can i scrape information from whatsapp group? Varaiables like Gender, chats from participants, period et al. Would like to run analytics on such. Hoping to read from you.

[neetufabiyani]

how do you go back to source data (appiled steps) after you have created function.please help