Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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.
Happy to help!
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.
Happy to help!
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)
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
10 | |
8 | |
7 | |
6 | |
6 |