Forum Discussion
Power Query
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 pa...
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!
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
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?
- 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
Yes, it's as OCR on Excel mobile - it works fine on samples but not in real life. However, also have limited experience.
