cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
hullterry Frequent Visitor
Frequent 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
Moderator v-yuezhe-msft
Moderator

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 Frequent Visitor
Frequent 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

Moderator v-yuezhe-msft
Moderator

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 Frequent Visitor
Frequent 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
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 60 members 1,264 guests
Please welcome our newest community members: