Transforming PDF source unstructured data

Question

Dear Team,&nbsp;We are trying to import PDF file and to build report based upon that data.&nbsp;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.&nbsp;I tried to use R function (PDF connector utility) also to make the data structured but no luck.&nbsp;&nbsp;Can someone please suggest&nbsp; me the best way to transform this unstructured PDF data to structred way for usable. Thanks!

amitchandak · Answer

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 · Answer

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 · Answer

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.
&nbsp;
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 · Answer

Hi Amit,&nbsp;Sharing the PDF file after converting it as PNG.&nbsp;Example: (Required data output)Col1 - Col2Total Inbound -&nbsp;37,374Weekday Average -&nbsp;1,331Inbound malware detected - 171&nbsp;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.&nbsp;

Forum Discussion

Transforming PDF source unstructured data

4 Replies

Related content

Unstructured Source - Architecture in Fabric

Table Transformation

Transform columns / type

Unstructured data transform question

Transform an Unstructured table in Power Query