Pdf file not opening in Power query

[vrunda]

I am using Microsoft 365, Want to open Pdf file to extract data from it in power query, I tried to open 2-3 different files , bank statements, but its saying Unexpected error ," send frown", "close" etc.
How to solve this?

 

[Marc L]

Is your Excel version can at least open pdf files ?!​

​

 

[vrunda]

No excel is not opening pdf files. before it used to open but not now. I am going through Data tab>> get data>> from Pdf file
And I also want to ask if pdf file is password protected then can it be opened in excel in power query.

 

[AliGW]

If the PDF file contains a scanned image, then you won't be able to import anything into Excel or PowerQuery. It depends entirely on the nature and contents of the PDF.

 

[vrunda]

It is Bank Statement , Initially some tables in another pdf files used to open , but now the same type file is also not importing in power query.

Unexpected error ," send frown", "close" etc. And copy data to clipboard.... this dialogue box appears.

 

[SeeUik]

And I also want to ask if pdf file is password protected then can it be opened in excel in power query.

So let us know if the PDF is password protected.The more we know, the faster we can solve your problems.