Forum Discussion

CWPRenewables's avatar
CWPRenewables
Frequent Visitor
5 years ago

PDF as a Data Source - Tables across multiple pages

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...
Need Help
v-alq-msft's avatar
v-alq-msft
Community Support
5 years ago

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.