Solved: Get data from PDF is not displayed in Power Query

NASCH · ‎06-16-2022

Hello,
I am using Excel 2016, Windows, and option to get data from PDF is not displayed in Power Query. Any ideas how to resolve it?
Thank you.

Vijay_A_Verma · ‎06-16-2022

Since you are not having higher version of Excel, Use Power BI Desktop which is free and can be installed from

64 bit - https://download.microsoft.com/download/8/8/0/880BCA75-79DD-466A-927D-1ABF1F5454B0/PBIDeskt...

32 bit - https://download.microsoft.com/download/8/8/0/880BCA75-79DD-466A-927D-1ABF1F5454B0/PBIDeskt...

Here, you can work with your pdf document, transform the data in Power BI Desktop, then you can right click on your table name on right - Copy table and paste into Excel (there are many ways to get data into Excel but this is the simplest)

View solution in original post

Vijay_A_Verma · ‎06-16-2022

Since you are not having higher version of Excel, Use Power BI Desktop which is free and can be installed from

64 bit - https://download.microsoft.com/download/8/8/0/880BCA75-79DD-466A-927D-1ABF1F5454B0/PBIDeskt...

32 bit - https://download.microsoft.com/download/8/8/0/880BCA75-79DD-466A-927D-1ABF1F5454B0/PBIDeskt...

Here, you can work with your pdf document, transform the data in Power BI Desktop, then you can right click on your table name on right - Copy table and paste into Excel (there are many ways to get data into Excel but this is the simplest)

Greg_Deckler · ‎06-16-2022

@NASCH Use Excel 2019 or some version of office that is not over half a decade old?

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...