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 Power BI file on GitHub for your reference. Please download it using the following URL.


Let’s get started!


Step 1

Update your Power BI Desktop and from "Preview Features", enable “Get data from PDF file”.
















Step 2

From Home, select Get Data.









Step 3

From All, select “PDF(beta)”.

















Step 4

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


Step 5

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













Step 6

It will show all the loaded fields.



















Step 7

We have the following types of data available in our PDF file.



















Step 8

Prepare Power BI report based on your requirement. I have uploaded 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.