oracle blob datatype not impoorting

[po]

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

[amitchandak]

@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

[po]

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?

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