Upload multiple PDFs with Multiple pages

Power Query
1

Hello-
I’m trying to upload daily PDFs into one report.
I created a folder with multiple files, but I cannot select all data . I have an option for one table or one page.
Is it possible to do an actual upload for all of them? Daily file can be one page or 3 pages, it’s always random.

Thank you!
Natasha
Combine_PDFs_ByPage.xlsx (29.4 KB)
CombinePDFs-byTable.pbix (28.8 KB)
PO1131197.pdf (5.6 KB)
PO1131199.pdf (3.5 KB)

2

Hi @npower,

When you select “Pages” you can build logic to extract whatever you need from all those PDF’s in the folder. There’s content about this in the portal, check out these 2 resources:

Innovations In Power BI & Power Platform Summit, session: Extract Data From PDF’s
Applied Problem Solving with Power Query/M, chapter: Convert a PDF to a Tabular Format

Should you need assitance, its helpful to provide a file with the expected outcome.
I hope this is helpful

3

Hello @npower

Did the responses above help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION

Thank you

4

Hi @npower

Due to inactivity, a response on this post has been tagged as “Solution”.

If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.

We request you to kindly take time to answer the Enterprise DNA Forum User Experience Survey,.

We hope you’ll give your insights on how we can further improve the Support forum. Thanks!

5

Thank you very much for your help!
I think I fix the upload issue. However one of the files (PO1132436.pdf) doesn’t go through the steps.
Do you think you can help me to understand what’s wrong on my end? or it’s just PDF format in general
Thank you again for your help!
Combine_PDFs_ByPage-Sysco.xlsx (33.6 KB)
PO1131197.pdf (5.6 KB)
PO1131199.pdf (3.5 KB)
PO1132029.pdf (5.8 KB)
PO1132032.pdf (3.5 KB)
PO1132436.pdf (3.6 KB)