ETL Query with multiple PDF'S

Hey

This is very much possible, it’s a matter of how much effort you want to put into it. i.e. for each customer, you’ll need to have different queries as the pdf layout is different - meaning multiple queries to maintain.

The below video is by Gil Raviv who is bit of a power query legend. At some point in the presentation he goes through the process of pulling Covid-19 data from publicly available WHO pdfs. I think it will help give you some ideas on how this could work for you.