Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

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

6 REPLIES 6
V-pazhen-msft
Community Support
Community Support

@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
Not applicable

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
Not applicable

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
Super User
Super User

@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?


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Anonymous
Not applicable

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).

@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?


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.