Forum Discussion

Cha1234's avatar
Cha1234
Copper Contributor
Jan 22, 2021

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 pages?

 

Thank you

BI & Data Analysis
excel
power bi

6 Replies

  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Jan 22, 2021
    Are you wanting to combine several PDFs or just several pages from within one PDF?
    • Cha1234's avatar
      Cha1234
      Copper Contributor
      Jan 22, 2021

      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!

      • Wyn Hopkins's avatar
        Wyn Hopkins
        MVP
        Jan 22, 2021

        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

         

         

         

         

         

         

Resources