Transforming PDF source unstructured data

[DivakarKrishnan]

Dear Team,

We are trying to import PDF file and to build report based upon that data.

When I am importing PDF in power Query using PDF connector, data is not coming in tabular format and it's completely scattered to multiple cells.

I tried to use R function (PDF connector utility) also to make the data structured but no luck. 

Can someone please suggest  me the best way to transform this unstructured PDF data to structred way for usable. Thanks!

[amitchandak]

@DivakarKrishnan , is data in table ?

if yes, refer

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-pdf

https://www.sqlshack.com/importing-data-from-a-pdf-file-in-power-bi-desktop/

https://www.mssqltips.com/sqlservertip/5845/read-and-import-data-from-pdf-files-using-power-bi/

[DivakarKrishnan]

Hi Amit, Data is not in a table structrue, that is why i am facing issues. Almost, i referred all these links, it's not helping for my usecase.

[amitchandak]

@DivakarKrishnan , Can share some examples of what kind of text and what you need to do with that. Might have to use R or Python.

There is something in august 2020. But not for pdf yet

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2020-feature-summary/#_text_csv

[DivakarKrishnan]

Hi Amit,

Sharing the PDF file after converting it as PNG.

Example: (Required data output)

Col1 - Col2

Total Inbound - 37,374

Weekday Average - 1,331

Inbound malware detected - 171

I have tried R function (PDF utility) but still values are scattered to different different cells, and from there i am not able to transform further.