Read Tables from PDF in Power Query M

Extracts tables from a PDF file using Power Query's built-in PDF connector.

File HandlingIntermediatepdftablesextractconnector

Power Query M code

let
    Source = Pdf.Tables(File.Contents("C:\Data\Report.pdf"), [Implementation = "1.3"]),
    Page1Table1 = Source{[Id = "Table001", Page = 1]}[Data]
in
    Page1Table1

Notes

Pdf.Tables returns one row per detected table; browse Source in the Navigator to find the right Id/Page for your document.

Requirements

A PDF file containing tables the connector can detect.

How to use this snippet

In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Read Tables from PDF.