Get data from PDF is not displayed in Power Query

[NASCH]

• 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 · Accepted solution]

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]

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