Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric certified for FREE! Don't miss your chance! Learn more

Tables in PDF files

I have come across so many public data repositories that hold data in PDF format. Other websites have tables within documents such as annual reports etc., also in PDF format. A data source for PDFs or tables from PDFs would be awesome!
Status: Completed
Comments
johnkgn
New Member
I can't believe having a PDF as a source file is not already included. PDF's are so common and are the most troublesome to work with.
spillerbd1
New Member
Exactly as Ken Puls states... I am looking at a bank statement that is 186 (and sometimes statements that much, much bigger) pages long. I can use NitroPro to convert the document to straight txt file and then bring it into Excel, either directly or through PQ. But cutting that conversion step to txt is one of the big reasons I thought PQ exist? Considering that some PDF's are the only source for certain data dissemination, I am really surprised that it is not yet a valid source for PQ.
anthony_newell
New Member
Here's my input on this idea: 1) Ability to extract from a document (PDF or Word) If you received a data source on a regular basis in document format that had a regular embedded table of data you could extract it using PQ 2) Convert a set of reports in PBI to PDF document to enable you to produce and distribute a hard copy report pack by email or upload to Sharepoint. Sometimes the requirement is to have reports consumed in this way so this is greater flexibility opening up more usage possibilities for PBI
maxwell_r_gregs
New Member
This is huge for professional services firms too. Even if the result had to be cleaned up after. The biggest ask we get is to be able to extract the data held in tables within pdfs which feels like it should be an easy/easier solution.
pbiideas1
New Member
Just Have
Naveen_NAV
New Member
Great idea
janl0254
New Member
Any update on this, start
sumantomukherje
New Member
Great Idea
miles_colin
New Member
Many individual business are now sending PDF receipts via email, ability to parse data would be amazing for granular project visibility.
redgumbusinesss
New Member
I have a customer that wishes to analyse their phone bill, but the "electronic" version their provider sends them is a 400 page PDF document!! You can use Excel as an intermediate step, but columns get transposed so manual data wrangling is still required. This feature cannot come soon enough!