PDF as a Data Source - Tables across multiple pages

[CWPRenewables]

I was wondering if anyone knew what might be causing the difference between these two PDFs?

PDF1 Table002 crosses page 1&2, but PDF2 the same data is split between Table002 and Table003.

I want all my PDF's to be like PDF1.

PDF1

PDF1 - Table002 (Page 1-2)

PDF2

PDF2 - same data (different month) split across two tables

I suspect it is a setting difference when the PDF is first generated, but as I don't generate these, I am not sure what to ask the owner to do for consistency.

[v-alq-msft]

Hi, @CWPRenewables 

I wonder if two PDFs have same format. In navigator window, you can select one or multiple elements to import and use in Power BI Desktop. you may also specify the Start page and End Page as optional parameters for your PDF connection. You can also specify these parameters in the M formula language, using the following format:

Pdf.Tables(File.Contents("c:\sample.pdf"), [StartPage=10, EndPage=11])

For further information, please refer to the document .

Best Regards

Allan

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