cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

pdf as a data source?

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

 

TIA


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
1 ACCEPTED SOLUTION

Accepted Solutions
v-ljerr-msft Super Contributor
Super Contributor

Re: pdf as a data source?

Hi @vanessafvg,

 

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

 

Other references:

Idea of importing Table s in PDF files

Import Data from PDF using Power Query

 

Regards

3 REPLIES 3
deldersveld
Advisor

Re: pdf as a data source?

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.

v-ljerr-msft Super Contributor
Super Contributor

Re: pdf as a data source?

Hi @vanessafvg,

 

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

 

Other references:

Idea of importing Table s in PDF files

Import Data from PDF using Power Query

 

Regards

Super User
Super User

Re: pdf as a data source?

@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


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!