Create Power BI Report Using PDF Data Source

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”.

Step 2. Getting data from PDF

From Home, select Get Data.

Step 3. Previewing PDF pages

From All, select “PDF(beta)”.

Step 4. Preview connector

It will prompt a message saying this is a preview connector. Click on OK.

Step 5. Loading data

It will show all the available pages with its preview. Click on Load.

Step 6. Show all the loaded fields

It will show all the loaded fields.

Step 7. Types of data in PDF

We have the following types of 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.

Conclusion

This is how we can consume the data from a PDF file and prepare our Power BI report.