Forum Discussion
Transforming PDF source unstructured data
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...
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.
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
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.