PBI Dataset - binary column

[Markzolotoy]

I want to know is there size limitations for a binary coumn type?

Also will the binary column take a memory stream from C#?:

byte[] imageBytes = Convert.FromBase64String(string);
MemoryStream exportStream = new MemoryStream(imageBytes, 0, imageBytes.Length);

Thanks

[v-deddai1-msft]

Hi @Markzolotoy ,

Here is a good sample for your reference :https://www.c-sharpcorner.com/blogs/load-image-file-in-power-bi-from-sql-server

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[lbendlin]

Are you sure you can then actually display these binary images in the Power BI UI? via the Image URL?

[Markzolotoy]

Paginated repot should be able to display images stored in binary columns of SQL table.

[Markzolotoy]

I am specifically asking about a straight forward way of retrieving images - binary, not a work around using Base64 strings.

[lbendlin]

The documentation does not mention any size limit for the binary cloumn type

Data types in Power Query | Microsoft Docs

There are many examples of image data being stored in Power Query columns https://blog.crossjoin.co.uk/2019/05/19/storing-large-images-in-power-bi-datasets/

but most of them use a text encoding .