Power BI: How To Extract Data Stored In PDF Format

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to extract data that I stored in PDF. Let’s get started

In the caption below, we have the Transaction data stored in PDF and we would like to extract the data in Power BI for further analysis

To extract: In the External Data group of the Home tab, select More from the dropdown

In the Get Data dialogue box, select PDF and click on Connect

Select the PDF file from the location

In the Navigator dialogue box, check Table001(Page1) box and click on Transform

In the caption below, we can see that the data has been extracted in the Power BI Power Query for further analysis

Posted in Blog.

Leave a Reply

Your email address will not be published. Required fields are marked *