cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jeromethibaudea
New Member

Import data from fillable pdf

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.

1 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

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

any 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

 

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

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors
Top Kudoed Authors