Forum Discussion
PBI Dataset - binary column
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
5 Replies
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 .
I am specifically asking about a straight forward way of retrieving images - binary, not a work around using Base64 strings.
Are you sure you can then actually display these binary images in the Power BI UI? via the Image URL?
Paginated repot should be able to display images stored in binary columns of SQL table.
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
