Full image not displaying in report

[Justair07]

Hi,

I have some SQL data imported as Binary. I follweed the steps here to convert to text and then convert the text to image URL format. The issue is when I add the image field to a table on my report, 90% of the all images are cutoff and I can only see the very top of each image, see picture:

Any help is very much appreciated.

Thank you,

- Justair07

[Justair07]

Upon doing research it appears that my Image data type coming from SQL exceeds the Power BI character limitaion of 32,766. My Binary value of my image data is 43k~. That being said, does anyone have a solution for me? Maybe a way to compress the image size prior to import programmatically? Or some M code to split the image data over multiple columns so I can use a DAX statment to piece it back together? I'm open to all potential solutions.

Thank you,

-Justair07

[dax · Accepted solution]

Hi @Justair07 ,

You could try to convert image to base64 or you could upload the image in sharepoint or onedrive to see whether it work or not. You could refer to this video  and power-bi-using-onedrive-to-embed-and-host-images-for-power-bi/  for details.

When you load image from sharepoint, you could use below M code, then set Custom column->Modeling->Data Categoty->Image URL(Which coud work in service not in desktop)

let
    Source = SharePoint.Files("https://<company>.sharepoint.com/teams/fortest2", [ApiVersion = 15]),
    #"Filtered Rows" = Table.SelectRows(Source, each ([Extension] = ".jpg")),
    #"Added Custom" = Table.AddColumn(#"Filtered Rows", "Custom", each [Folder Path]&[Name]),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Content", "Extension", "Date accessed", "Date modified", "Date created", "Attributes"})
in
    #"Removed Columns"

Best Regards,
Zoe Zhi

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