Click here to Skip to main content
15,867,686 members
Articles / PDF

Import PDF Data in Power BI–Really Excited to See

Rate me:
Please Sign up or sign in to vote.
5.00/5 (1 vote)
8 Mar 2019CPOL2 min read 6.3K   1   1
How to import PDF data in Power BI

Every month, Microsoft Power BI team brings out new features to make Power BI a more robust tool. To add a feather in the cap of Microsoft Power BI tool, Microsoft Power Team introduced a really exciting feature which is import data from PDF.

There are various scenarios where we have to deal with PDF data and do some fruitful operation on it. I hope this new feature will help us in those scenarios where data source is PDF.

Isn’t it cool? Let’s experience this feature by using some hands on.

Prerequisites: The first and foremost important point is that it is feature preview, so just download the latest Power BI using this URL.

Once you download, then enable the preview feature of import Power BI data using options’s Preview feature item. Just select the option Get data from PDF File.

import_data_From_Pdf_step_1

Once you selected the option, you might need to restart the power BI.

Now, obviously, the next step is to choose the source, in this example, I downloaded a PDF from the Internet and am using it. In this data source, we have Employee(Contact Name), Title Company, Name Country, etc.

Import_Pdf_Data_Step_0

Now, go to new data source and select the data source with option Power BI as shown in the below figure:

Import_PDF_DATA_Step_2

Once you click on the option, in the next step, provide the source pdf file which you need to import. As you are aware, we are importing Contact information related grid.

As you can see in the below figure, POWER BI imported various tables in that specific table.

In this case, we are opting for Table001 {page –10).

Import_Data_From_Pdf_Step_3

Once this is done, click OK button and apply:

Import_Pdf_Data_Step_4

Now, we have PDF grid data. In the next step, just apply some steps to clean the data. After few steps like renaming the columns, remove extract column and use column header, etc. implementation. We will get our grid of data imported from PDF.

Import_Pdf_Data_Step_6

import_Pdf_Data_Step7

Now, we can run a chart to determine contractor in each country.

import_Data_From_Pdf_Step_8

So we have successfully gone through the option of import PDF DATA.

Hope this will come in main line data source soon.

Happy learning!

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Team Leader
India India
I am Rajat Jaiswal from India. I am working as a Technology specialist in one of the reputed company in India with 12+ years of experience. I am a Microsoft Data Platform MVP & Alibaba Cloud MVP.
I have always had an affinity to learn something new in technology. Database, Web development, Cloud computing are the areas of my interests always.
I have been a regular contributor to technologies with more than 300+ tips. Learning & Sharing is one of my aims always. Writing blogs, delivering sessions, helping on forums is my hobby.

Comments and Discussions

 
GeneralMy vote of 5 Pin
Member 1236439011-Mar-19 1:41
Member 1236439011-Mar-19 1:41 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.