SQL Varbinary Encountered internal error

[SkiDK]

Hi everyone,

I have an SQL (on-premise) table with a Varbinary(max) column. In this column thumbnails are stored, so the size of the images are quite small.

Suddenly PowerApps does not recognize the data type anymore when pulling the records from the table. I get next error in the field for the column:

I have tried changing the data type to 'Image' (of course which I shouldn't because it will be depreciated) but also the same result. The weird thing is that 10 days ago it worked perfectly. I could pull the images and show them in the app. 

I came across posts telling Varbinary isn't supported in PowerApps, but then also posts that say it does get supported.

Can anyone help me?

Many thanks!

[SkiDK]

Bump. Anyone that can help me?

[SkiDK · Accepted solution]

Okay, found out what was wrong. The blob in the Varbinary column was actually not stored as an image, but as a string. It filled the column as a hexidecimal notation anyway. Sooo, if this happens and you come across this post, it's probably Powerapps that doesn't recognize the type of the blob, which makes sense.

Hereby, and luckily, nothing wrong with PowerApps 😅