How to open PDF files in Power BI by getting Blob from Oracle Database

[Anonymous]

Hi, I am looking for some help on Power BI Desktop.

I would like to show our full Invoice images (pdf). This is stored in Blob format in our Oracle SQL Database.
We have tried to use the Pdf Viewer from the custom visual options. This only allows me to get one image and errors on multiple

Please help me out!

Kind regards,

Sonicks

[V-pazhen-msft]

@Anonymous 

Once you connected to database, please follow the guide in the following blog to convert the binary field to image.

Storing Images in a PowerBI/Analysis Services Data Models | Gerhard Brueckl on BI & Data (gbrueckl.at)

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @V-pazhen-msft, and thank you for your reply. Your solution is the first thing I tried.
We are looking for a full-size presentation of scanned files. These are stored in BLOB in the database.

[Anonymous]

Thank you @V-pazhen-msft, to send me this blog. We are trying to achieve a full-size PDF file. I've tried this solution before but did not work out. This only helps to add small pictures on tables right?

[AllisonKennedy]

@Anonymous  I'm not sure what you're trying to achieve here - can you add a slicer for Invoice # so that you only have 1 invoice/image displayed at a time and user must select or type invoice # to get result?

[Anonymous]

Hi @AllisonKennedy Thank you for your reply. Unfortunately, the slicers do not solve the problem.
We try to achieve a full-sized PDF. When we select an invoice number, we would like to see the scanned files in PDF form (blob-stored in oracle DB).

[AllisonKennedy]

@Anonymous I'm still not clear exactly what the requirement is, but it sounds like you may be looking for PowerApps functionality more than Power BI? Are there multiple PDFs per invoice number?