Forum Discussion
Import data from fillable pdf
Doesn't look like Pdf.Tables - PowerQuery M | Microsoft Docs is of any help here. It barely recognizes the holding table (Table005 in your case). Short of implementing your own PDF parser this might not currently be possible.
Super Userany chance you could post a sanitized version of such a PDF file?
Here are a couple of link to the pdf. I would be looking to extract the information provided in Section J, # of fixtures requested.
- Sanatize example of the PDF: https://drive.google.com/file/d/1VK1WP3j2vVcZ7CZ9eBMviDGvLw42WggM/view?usp=sharing
- blank pdf form: https://www.surrey.ca/sites/default/files/media/documents/PlumbingPermitApplication.pdf
- lbendlin
Doesn't look like Pdf.Tables - PowerQuery M | Microsoft Docs is of any help here. It barely recognizes the holding table (Table005 in your case). Short of implementing your own PDF parser this might not currently be possible.