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
