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!
Update your Power BI Desktop and from "Preview Features", enable “Get data from PDF file”.
From Home, select Get Data.
From All, select “PDF(beta)”.
It will prompt a message saying this is a preview connector. Click on OK.
It will show all the available pages with its preview. Click on Load.
It will show all the loaded fields.
We have the following types of data available in our PDF file.
Prepare Power BI report based on your requirement. I have uploaded Power BI file on GitHub. Here is the URL.
This is how we can consume the data from a PDF file and prepare our Power BI report.