Import PDF data in Power BI–really excited to see

Although, in every month Microsoft Power BI team bringing new features to make Power BI 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 is the various scenario 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 the data source is PDF.

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

Prerequisites: The first and for the most important point is, that it is in feature preview so just download the latest Power BI using following URL.

Once you download then enable the preview feature of import Power BI data using options’ 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 using it. In this data source, we have Employee(Contact Name), Title Company Name Country etc.

Import_Pdf_Data_Step_0

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

Import_PDF_DATA_Step_2

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

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

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

Import_Data_From_Pdf_Step_3

Once this done. Click OK button and apply

Import_Pdf_Data_Step_4

Now, we have PDF  grid data now in the next step just apply some steps to clean the data.  after a 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 the 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 the main line data source soon.

Happy learning!

Microsoft MVP–A dream came true

 

Dear All,

Microsoft  Most Valuable Professional “ – MVP  is one of the prestigious tag. It is one of the dreams which came true today.

Today , I got the E-mail that I am an MVP in SQL SERVER. 

I am speechless but would like to say a big thanks to everyone who provided their feedback all the time , motivated me each and everyone who helped me to learn more and more.

A special thanks to Sir Jeff Moden  who provides inputs all the times.

Thank you everyone

Thanks for inspiring Smile

Keep sharing  & keep learning

Thanks

RJ