cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
wifc5013
Frequent Visitor

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

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 readpdf read

1 ACCEPTED SOLUTION
ibarrau
Super User
Super User

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 pdfsExpand 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.


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

View solution in original post

2 REPLIES 2
ibarrau
Super User
Super User

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 pdfsExpand 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.


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

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)

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors