Unable to import a PDF

[Noel Lackey]

Hi,
I am trying to import a PDF into Power Query, the PDF is not password-protected and opens with no problem. I am using Office 365 for enterprise. This is the error I am getting Details: "Pdf failed to load with result: Corrupted"
Any advise greatly appreciated,

 

[AlanSidman]

Please attach the PDF file here so that we can investigate the probable cause. Without the file, it would only be wild guesses as to the issue.

 

[Noel Lackey]

Hi Alan,
thank you for replying, it is a bank statement so unfortunately I can't share it
Best Regards,
Noel

 

[Marc L]

Hi, so something weird with your file, the reason why it can't be handle under Excel …​

But you can manually copy data from the file and paste them to a worksheet.​

​