Import data from fillable pdf

[jeromethibaudea]

Hi, 

I'm having issues importing data from a PDF fillable form into PowerBI. I'm familiar and able to import content from a pdf, but the content inputted through the fillable pdf form is nowhere to be found. 

I intend to import the content of a pdf applicaiton forms into PowerBI to analyse the submission responses for trends and completeness. I can import one pdf and access the underlying questionnnaire text/tables without issues, but the applicant's submission, the content to be analysed, is not available in the pdf content import.  To date, I have tried flattening the pdf, but without success. 

Any insights into this is appreciated. 

Thanks in advance.

[lbendlin]

any chance you could post a sanitized version of such a PDF file?

[jeromethibaudea]

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 · Accepted solution]

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.

Extract PDF Form Data FDF - Microsoft Power BI Community