Partial automation is better than none!

Using Power Query to append web data

I recently used this process with a client to extract KPI data from one of their web systems and create reporting. Its a workable process any company with Microsoft Excel and a shared data folder can implement to take a lot of manual steps out of reporting.

Leave a comment