Overview
In this article, we will talk about how we can consume data from a PDF file and prepare the Power BI report consuming that PDF file. Power BI provides a PDF Connector using which we can consume the data from a PDF file.
I have uploaded a sample PDF data source file and a Power BI file on GitHub for your reference. Please download it using the following URL.
Let’s get started!
Step 1. Enabling PDF connector
Update your Power BI Desktop and from "Preview Features", enable “Get data from PDF file”.
![Preview features]()
Step 2. Getting data from PDF
From Home, select Get Data.
![Get data]()
Step 3. Previewing PDF pages
From All, select “PDF(beta)”.
![Select pdf]()
Step 4. Preview connector
It will prompt a message saying this is a preview connector. Click on OK.
![Click on continue]()
Step 5. Loading data
It will show all the available pages with its preview. Click on Load.
![Table]()
Step 6. Show all the loaded fields
It will show all the loaded fields.
![Fields]()
Step 7. Types of data in PDF
We have the following types of data available in our PDF file.
![Data available in our pdf file]()
Step 8. Power BI Report preparation
Prepare a Power BI report based on your requirements. I have uploaded the Power BI file on GitHub. Here is the URL.
![Policy count by customer no]()
Conclusion
This is how we can consume the data from a PDF file and prepare our Power BI report.