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

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

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
MaxonSh
Advocate I
Beyond just importing a chart from a PDF, we need to be able to import a chart in a collection of PDFS with a consistent format in a folder. For example, a report in a standardized format is received on a weekly basis. We need to be able save the PDFs for a SharePoint Online folder and then let Power BI find each chart to append them together. This is a powerful feature that work for multiple Excel files in a folder, so replicate the same with PDFs.
terry_hull1
New Member
It would be good if this could also read the data from formatted fields within the PDF. I believe they maybe in a fdf format. But as they are named fields it should be relatively easy to show a list of fields by column. And let you import like other files. Currently the data is not imported at all
fbcideas_migusr
New Member
Feature is working fine in my applications. When will this be shipped with Excel Get & Transform since I prepare my data in Excel and I have to log the data imported?
ttyler
New Member
This is great but I've come across where the data becomes corrupted and produces errors in the editor. My source is a folder and I have 2 PDFs sent to me daily that I drop in that folder. The PDFs are identical except for the dollar amounts. Inconsistently; BI will corrupt one or a few of the documents when I refresh the dashboard.
mattiarusso
Advocate I
Hello Everybody, the pdf connector works only for PBI Desktop. When i try to use a Gateway on a dataset that use a pdf Connector the Gateway doesn't work!!!! Are you working on it? When will fix this bug? thanks in advanced! Mattia
fbcideas_migusr
New Member
When will this be available in Get & Transform in Excel? Urgently needed.
fbcideas_migusr
New Member
A heads-up that while this feature kind-of worked in the November 2018 release, it was totally wrecked in the December 2018 update - the table and row detection broke to the point it was unusable. The good news is the February 2019 update has fixed those problems and improved the detection of similar tables on subsequent pages - they are combined into one table. An odd new "feature" is that after detecting a table they leave you to manually add a Promoted Headers step - ideally that would be generated. I've worked on many projects with multiple similar technologies over the years (Tabula was my previous fav). It's always a little messy due to the limitations of the PDF format. But I feel more confident tackling them in Power Query, with all it's glorious data transformation power at my fingertips. Thanks Amanda and team!
leonord
New Member
We're looking for sharing features to be available to non-designers. That report consumers/viewers can use them when embedded, regardless of embed methods. This feature would be most useful (for us) when this can be applicable outside the power bi app and the power bi service. In the same light, export to PDF is most useful when its embedded, ie beyond Power BI app and beyond Power BI service.
Ehren
Microsoft Employee
To all those who have feedback to share about this feature, please send me a private message on the Power BI Community. We want to hear from you! https://community.powerbi.com/t5/user/viewprofilepage/user-id/33215 Ehren
fbcideas_migusr
New Member
Super for Power BI, when available in Excel Get&Transform?