• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Unable to import a PDF

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,
 
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.
 
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.​
 
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,
Something I would try is to open the file with a real PDF software (Adobe, Foxit,..., so not a browser) and save a copy as pdf.
Then try the PQ thing with that copy.

Or since it's a bank statement, you might be able to download it again from your bank through the bank app? As the error message may hint it's a rendering issue. If people have complaint to the bank, they may have solved the bug if it was something recurring.

another thing to try is explained by Microsoft here https://learn.microsoft.com/en-us/power-query/connectors/pdf. There is a section explaining how to use the start and end page parameter from Pdf.Tables function. If you are lucky you can read just that part of the PDF you need.
I would also look at implementation version: https://learn.microsoft.com/en-us/powerquery-m/pdf-tables:
1738497644838.png
 
Back
Top