pdf as a data source?

[vanessafvg]

Just wondering if anyone has successfully set up a process to extract from a pdf?

TIA

[v-ljerr-msft · Accepted solution]

Hi @vanessafvg,

Here is a similar thread in which some solutions are mentioned there. Could you go to check if it helps? 

Other references:

Idea of importing Table s in PDF files

Import Data from PDF using Power Query

Regards

[deldersveld]

There is no way to directly process from a PDF, but you could use an outside (free) tool like Tabula to extract to CSV as described in this post: https://dataveld.wordpress.com/2017/05/28/power-bi-analytics-challenge-part-2-processing-data-from-a...

If you would like to use R, you could also try packages such as pdftools or tm.

[vanessafvg]

@deldersveld r sounds like a good posssiblity as i am assuming you can automate it, @v-ljerr-msft this i did see but it doesn't look automatable.

I did vote on the idea link, that would be great functionality, thanks all

[Anonymous]

did you find a way to automate the process of importing the PDF Data?