Skip to main content
Microsoft Idea

Power BI

Completed

Tables in PDF files

Vote (3044) Share
Gogula Aryalingam's profile image

Gogula Aryalingam on 17 Jan 2015 03:15:10

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!

Administrator on 13 Apr 2019 00:56:11

The PDF connector is now generally available in the April release of Power BI Desktop. Learn more here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-2019-feature-summary/#pdf

Comments (284)
Gogula Aryalingam's profile image Profile Picture

Richard Junker on 05 Jul 2020 22:54:59

RE: Tables in PDF files

I'm moderating a webinar next month on scrubbing data and importing data to Excel. An MVP is the speaker. It would be so cool if he could announce to the audience of actuaries that Excel can digest numbers from PDFs.

Financial statements in PDF format are a pain to attempt analysis.

Gogula Aryalingam's profile image Profile Picture

John Jalo on 05 Jul 2020 22:54:59

RE: Tables in PDF files

It would be nice to have this feature in Excel. The current PDF converter tool to export a PDF to Excel is lacking in functionality. A majority of the time the conversion to Excel is very difficult to work with.

Gogula Aryalingam's profile image Profile Picture

Benedikte Whitman on 05 Jul 2020 22:54:59

RE: Tables in PDF files

I would find the ability to get data out of PDFs and into Excel very useful and probably use it often.

Gogula Aryalingam's profile image Profile Picture

Annonymous on 05 Jul 2020 22:54:59

RE: Tables in PDF files

Would be very helpful

Gogula Aryalingam's profile image Profile Picture

Larry Rubens on 05 Jul 2020 22:54:59

RE: Tables in PDF files

I agree. Either typing if file is small enough or finding another way is hardand subject to human error.

Gogula Aryalingam's profile image Profile Picture

Terry Power BI User on 05 Jul 2020 22:54:59

RE: Tables in PDF files

This would be a 'huge' feature

Gogula Aryalingam's profile image Profile Picture

Ryan on 05 Jul 2020 22:54:59

RE: Tables in PDF files

HUGE! Need native support on this.... Adobe Pro can do it, but needs to be a function in Excel!

Gogula Aryalingam's profile image Profile Picture

Annemarie Glass on 05 Jul 2020 22:54:59

RE: Tables in PDF files

this would be an excellent feature. hope it becomes a reality in the near future.

Gogula Aryalingam's profile image Profile Picture

Power BI User on 05 Jul 2020 22:54:59

RE: Tables in PDF files

Absolutely need this functionality.

Gogula Aryalingam's profile image Profile Picture

Power BI User on 05 Jul 2020 22:54:59

RE: Tables in PDF files

Yes, converting PDFs to Excel would be great!