Power-BI: importing folder of multiple PDF files where table needs to be "transposed"

JDR 1 Reputation point
2021-09-29T12:57:17.953+00:00

Hello,

I'm having an issue importing multiple pdf files in a folder. Each pdf files contains a "sideways" table where the header is on the left of the table and the information is on the right.
No issue when importing a single pdf and using transpose.

E.g.

Example PDF file content in each PDF

Date: 2021/09/21
Sequence No: 12
Amount: 2300
Description: Sample Text
Remarks: Sample Text

End result should be a single table containing information from all PDFs:

Date: Sequence No: Amount Description Remarks
2021/09/21 12 2300 Sample Text Sample Text
2021/09/23 13 3390 Sample Text Sample Text
2021/09/27 14 1310 Sample Text Sample Text

Thank you for any suggestions.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,985 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dave Patrick 426.1K Reputation points MVP
    2021-09-29T13:04:19.26+00:00

    Power Bi is not currently supported here on Q&A. The product group for Power Bi actively monitors questions over at
    https://community.powerbi.com/

    --please don't forget to upvote and Accept as answer if the reply is helpful--

    0 comments