Power Query

%3CLINGO-SUB%20id%3D%22lingo-sub-2085849%22%20slang%3D%22en-US%22%3EPower%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2085849%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20import%20several%20pdf%20of%20several%20pages%20into%20Power%20Query.%3C%2FP%3E%3CP%3EWhen%20I%20click%20on%20combine%20and%20transform%2C%20i%20can%20only%20select%20either%20one%20table%20or%20one%20page%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Cha1234_0-1611300696101.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F248489iB45B876079FCEE41%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Cha1234_0-1611300696101.png%22%20alt%3D%22Cha1234_0-1611300696101.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHow%20can%20I%20select%20all%20pages%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2085849%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2085966%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2085966%22%20slang%3D%22en-US%22%3EAre%20you%20wanting%20to%20combine%20several%20PDFs%20or%20just%20several%20pages%20from%20within%20one%20PDF%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2085988%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2085988%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3BSeveral%20pdfs%20of%20several%20pages.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20combine%20one%20pdf%20of%20several%20pages%2C%20I%20have%20to%20process%20all%20pages%20seperatly%20in%20the%20POwer%20Query%20dashboard%20and%20the%20output%20is%20displayed%20in%20different%20tabs%20in%20excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20your%20for%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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:

Cha1234_0-1611300696101.png

How can I select all pages?

 

Thank you

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

@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

 

image.png

 

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

image.png

 

 

 

 

 

 

@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

@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.