best practice for displaying blobs in power bi

[po]

Hi,

We have an oracle database where we get supplid signatures and these stored as blobs in database.

When we import these to power bi can see these show as binary datatype.

If we change the datatype of the signature to text within power bi and then add custom column as per below with the customer column as an image url we can see the signatures as expected 

"data&colon;image/<image_format>;base64,"&table[SIGNATURE]

I have a couple of questions.  

1)   Is there a better/different way to do this rathe than having to create extra custom column.

Ideally power bi coudl read the blob data directly from database.

2)   When no signature provided rathe than display blank image, is it possble to say "Not provided"

Thanks

[v-luwang-msft]

Hi @po ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.

Best Regards

Lucien

[v-luwang-msft]

Hi @po ，

The following article tells how to load blobs and images into a Data Model，you could have a look.

Load blobs and images into a Data Model

 

Wish it is helpful for you!

Best Regards

Lucien

[po]

Hi,

Thanks for reply.  link though look sto refer to excel rather than power bi

[v-luwang-msft · Accepted solution]

Hi @po ，

The following blog to convert the binary field to image  by use Power BI.😄

Storing Images in a PowerBI/Analysis Services Data Models

Best Regards

Lucien

[po]

Thanks for info