Display base64 Image in a Table -- Direct Query

[SaraAbdelazim]

I have an SQL database with a table of employees and a column of photos.
I used SQL query and created a new column (Photo) to store the Base64-encoded image data it's origionally in (Binary format).
I used this apprach :
* EmployeePhoto binary data from DimEmployee is cast as VARBINARY(MAX)
* CAST AS XML and xs:base64Binary
as suggested here by: @Lyssillic | Answer Display images from SQL Server database DirectQuery model 

I'm using DirectQuery Mode and the data is loaded successfully. (Power Query image below)
When I try to use the Photo column to show the images in a table in a report I get "Can't Load data for this visual"

Note: It works fine with images visualization or filtered table by single name (image below) BUT I wanted a table of all employees details+images 

Base64 images from SQLProblem when using photo column in report pagesingle value in image visual or filtered table

[SaraAbdelazim]

I did, as I mentioned I am able to display a single image if filtered by name. The problem is I can't display all of them..

[suparnababu8]

Hi @SaraAbdelazim 

If you not done this, pls do it to display images in matrix.

If you need more info on this pls visit below URLs

https://community.fabric.microsoft.com/t5/Desktop/Display-images-from-SQL-Server-database-DirectQuer...

https://community.fabric.microsoft.com/t5/Desktop/How-to-use-Images-Stored-in-a-SQL-Server-Table-wit...

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-images-tables

Thanks!