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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
po
Post Prodigy
Post Prodigy

oracle blob datatype not impoorting

Hi,

 

Have a view with orace blob datatype on it to store signatures and when choose to import can see the column - showing null 

.

 

When look at imported view in data view and fields imported no sign of this column.

 

Any reasons why this is the case?

 

Can we view oracle blob datatypes in power bi - if so how?

 

 

Thanks

2 REPLIES 2
amitchandak
Super User
Super User

@po , refer these two solution in past suggested how to handle blob. See if that can help you

https://support.microsoft.com/en-us/office/load-images-and-other-binary-typed-data-into-the-data-mod...

https://community.powerbi.com/t5/Desktop/Accessing-SQL-Blobs/td-p/1156760

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hi,

 

Thanks for reply and links.

 

However looks to mention pdfs.

 

Just wanting to have the signature which stored as blob visible and selectable in visuals.

 

Can see column when hit transform but but column not visible as column to even select.

 

Do you have steps/example pbix which does similar.

 

Imagien fairly common scenario - display images such as signature whcih stored a blobs on database in power bi?

 

 

signature.JPG

 

 

 

Trying below foudn on web from couple of years ago - but not sure if better way or will work 

 

  1. Change the data type of column which contain image/binary data, from binary to text. We need to add one more column to convert text to image url format.
  2. Go to "Add Column" and click on "Custom Column". It will open a window. Enter the column name and formula given below and click OK.

    “data:image/;base64,”&[ImageData]

  3. Now click on "Close and Apply" from the Home tab.

  4. On Data tab, select Image column and change its Data Category to Image url

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.