Import all PDF and tables within Power Query

[M_SBS_6]

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 has the same column headers. 

When I combine files it tells me to select a page or table but if I select Table001(page 1) that's all I get but for each PDF file, I want every table on every page. 

is there anyway of being able to do this please? 

[v-sgandrathi]

Hi @M_SBS_6,

Thankyou  @Akash_Varuna  for your reply on the issue.

I'm glad to hear that your query was resolved! If the response provided by the community member addressed your concern, kindly confirm.

Marking it as Accept Answer and give us Kudos if you found it helpful allows us to ensure that the solutions shared are valuable for the entire community.

If you have any further questions, feel free to reach out!

Thank you for your cooperation!

[v-sgandrathi]

Hi @M_SBS_6,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you.

[v-sgandrathi]

Hi @M_SBS_6,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thank you.

[Akash_Varuna · Accepted solution]

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]

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]

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

[M_SBS_6]

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