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
v-sgandrathi's avatar
v-sgandrathi
Community Support
1 year ago

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's avatar
    v-sgandrathi
    Community Support
    1 year ago

    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's avatar
      v-sgandrathi
      Community Support
      1 year ago

      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.