Forum Discussion

M_SBS_6's avatar
M_SBS_6
Helper V
1 year ago
Solved

Import all PDF and tables within Power Query

Hi,  I have 12 PDF files stored in sharepoint (example file name 2025-01-12T15_10_51+00_00.pdf)and in each file, there is 1 table per page (12 pages and 12 tables). Each PDF is monthly and always ha...
Need Help
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    Hi M_SBS_6 Could you please try these 

    1. Connect to SharePoint Folder:

      • Go to Get Data > SharePoint Folder, input the SharePoint URL, and load the PDF files.

    2. Extract All Tables:

      • Formula :
        Table.AddColumn(PreviousStepName, "Extracted Tables", each Table.Combine(PDF.Tables([Content])))
      • Replace PreviousStepName with the name of the step before this.

    3. Expand Combined Tables:

      • Expand the Extracted Tables column to show all rows from all tables across pages and files.
      • Remove unnecessary columns and ensure the headers are consistent.
        If this post helped please do give a kudos and accept this as a solution
        Thanks In Advance
Akash_Varuna's avatar
Akash_Varuna
Super User
1 year ago

Hi M_SBS_6 Could you please try these 

  1. Connect to SharePoint Folder:

    • Go to Get Data > SharePoint Folder, input the SharePoint URL, and load the PDF files.

  2. Extract All Tables:

    • Formula :
      Table.AddColumn(PreviousStepName, "Extracted Tables", each Table.Combine(PDF.Tables([Content])))
    • Replace PreviousStepName with the name of the step before this.

  3. Expand Combined Tables:

    • Expand the Extracted Tables column to show all rows from all tables across pages and files.
    • Remove unnecessary columns and ensure the headers are consistent.
      If this post helped please do give a kudos and accept this as a solution
      Thanks In Advance
M_SBS_6's avatar
M_SBS_6
Helper V
1 year ago

Thanks for your suggestion. I have followed the steps but my new column when I expand only shows the column headers (content, Name, extension etc) of the previous step not the headers within the PDF. 


onlyincludepdf Is my last step in the applied steps as I had to filter out excel files. 

=table.addcolumn(onlyincludepdf, "Extracted Tables", each table.combine(pff.tables(content)))

 

Have I done something wrong here? 

  • Akash_Varuna's avatar
    Akash_Varuna
    Super User
    1 year ago

    Hi M_SBS_6 You have written here pff.table(contents) its PDF.Tables(content)

    • M_SBS_6's avatar
      M_SBS_6
      Helper V
      1 year ago

      Apologies, that was my typo on here. It's as expected within Power BI