Power Query Select all Pages in an invoice, regardless of invoice length

[wifc5013]

Hello,

I am wondering if there is any way to have the get data -> PDF read all pages in an invoice, regardless of invoice length. We want to extract data from invoices we receive monthly. We want to name the invoice the same every time and put it in the same directory so PowerQuery can grab it, but the pages of the invoice will vary every time. Is there any way to "select all pages" so that PowerQuery always grabs them all? See below window for reference, and thanks!

pdf read

[ibarrau · Accepted solution]

Hi. I don't think it does it automatically. Maybe you can try this (but it will only work if the columns are exactly the same. Go to Source step after adding one table page and click the expand button with all columns. It should load all the pages with its columns. 

Expand pdfs

If this doesn't work then you should try reading csv files from a folder and the combine them. Check the Power Query code and try replicating it for the pdf.

Hope one of this works.

[wifc5013]

Thanks, editing the source step to expand all tables does work, however my invoices are not all the same format and I can only get them as pdfs, not CSV. But you did answer what I was looking for (select all tables)