cancel
Showing results for 
Search instead for 
Did you mean: 
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 III
Super User III

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



Has this post solved your problem? Please mark it as a 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. ?


I work as a trainer and consultant for Microsoft 365, 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?



Has this post solved your problem? Please mark it as a 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. ?


I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 


www.excelwithallison.com

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors