Power Query

[Cha1234]

Hello,

I would like to import several pdf of several pages into Power Query.

When I click on combine and transform, i can only select either one table or one page:

How can I select all pages?

Thank you

[#2]

Are you wanting to combine several PDFs or just several pages from within one PDF?

[#3]

@Wyn Hopkins Several pdfs of several pages.

If I combine one pdf of several pages, I have to process all pages seperatly in the POwer Query dashboard and the output is displayed in different tabs in excel.

Thank your for your help!

[#4]

Hi @Cha1234 

The option you might be after is this one

Then you can use the transform sample file,  filtering data and eventually click the expand icons above the Table list

[#5]

@Wyn Hopkins Thank you very much!!

I did it but there are some information that is not retrieve.

Would you know what I might do wrong?

[#6]

Too hard to say without the PDFs, In my limited experience of testing pulling data from PDFs it has missed data that's not that well structured in the PDF

[#7]

@Wyn Hopkins 

Yes, it's as OCR on Excel mobile - it works fine on samples but not in real life. However, also have limited experience.