Jan 21 2021 11:32 PM
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
Jan 22 2021 12:28 AM
Jan 22 2021 12:33 AM
@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!
Jan 22 2021 04:24 AM - edited Jan 22 2021 04:24 AM
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
Jan 22 2021 05:53 AM
@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?
Jan 23 2021 02:47 AM
Jan 23 2021 04:11 AM
Yes, it's as OCR on Excel mobile - it works fine on samples but not in real life. However, also have limited experience.