Web Scraping with Power Query: AFP DIY Automation Series

preview_player
Показать описание
Getting your data into Excel can be a chore, but Dr. Kevin Kelly, shows how to “scrape the web” to pull data in from URLs, transform and load it via Power Query to create a table ready for use. You can follow his methodology to pull in data from many external sources, including PDFs, databases and SaaS platforms.
Рекомендации по теме
Комментарии
Автор

This tutorial is great! I wonder if using HasData could streamline scraping from databases with Power Query.

EthanWalker-
Автор

Great insights here! Do you think HasData’s tools work well for scraping complex sites directly into Excel?

JuliuszTomaszewski-vg
Автор

This is super helpful! HasData's API for scraping might be an interesting tool to try alongside Power Query, right?

wulkynebabe
visit shbcf.ru