Get data from PDF option is missing in excel

Question

Hello, From long time I was using the option of Get data from pdf to excel by Data>Get data>From file>pdf

but recently I got update for the Microsoft office and after the update the option to get data from excel is missing.

I have Office 2019 Home & student. Detail images attached below.

Answer 1

But I have used I yesterday and after updating office the option is gone.

Answer 2

I have Office 2019 Home & student. Detail images attached below.

That version did not support this kind of import from the UI.

Create a text file in the same folder and the same name as your PDF.

Use Data \ From File \ From text, select the text and click Transfrom data

Look at the Source step in Power Query in the formula bar, you'll see something like this:

= Table.FromColumns({Lines.FromBinary(File.Contents("Z:\test.txt"), null, null, 1252)})

change it to

= Pdf.Tables(File.Contents("Z:\test.pdf"), [Implementation="1.3"])

If PQ is up to date on your PC it should import the PDF

Select the Table in the Data column you want to import.

See also
https://learn.microsoft.com/en-us/powerquery-m/pdf-tables

Andreas.