cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
hullterry
Regular Visitor

Extract PDF Form Data FDF

I have a large set of PDF forms with the data stored within each form in defined fields.

 

When using the new pdf tool it does not allow the defined fields to be extracted and simply shows the printed labels with out any of hte actual responded data ( I think because it is not built to extract data from forms but basically OCR a flat pdf)

 

Has anyone come across a way to extract the fields as columns wiht the record data as the rows of a table for this type of PDF?

 

 

4 REPLIES 4
Microsoft
Microsoft

Re: Extract PDF Form Data FDF

@hullterry,

Do you use PDF connector in Power BI Desktop? If so, could you please share a sample PDF file so that we can test?

Currently, the PDF connector is still in beta, and some features are not supported in this connector.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hullterry
Regular Visitor

Re: Extract PDF Form Data FDF

Lydia,

 

Hi yes tried the pdf connector ( was excited as thougth it owuld do the job) but it doesnt.

hope that a sample may help the development of this great tool.

all it curently returns is a list of some of the field names but no actual data that has been recorded.

what would be ideal is when it detects the field names bieng used it presents the option of what fields to retrieive as columns and then puts the values from each file into a row of a table

this would then mean you could use very easily within powerbi.

 

happy to share na example and have included link

 

https://1drv.ms/b/s!AqpViNAKUhclhf91FuONYFJtPs0ofw

file link of pdf form wiht data

 

 

many thanks for considering.

 

Terry

Microsoft
Microsoft

Re: Extract PDF Form Data FDF

@hullterry,

Please submit a feature request in Power BI Ideas forum.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hullterry
Regular Visitor

Re: Extract PDF Form Data FDF

ok have submitted a feature request ,

 

Update PDF connector to retrieve form data from fillable PDF

 

thanks

 

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors