Skip to main content

Power BI

Needs Votes

Data Model Image (Binary) Support in Reports

Vote (644) Share
Dan English's profile image

Dan English on 27 Mar 2015 03:48:52

I was all excited today that I was finally able to get images (binary) files loaded into my power query in the Power BI Designer. This took a bit getting around the Privacy settings and bugs, but the latest release of the Power BI Designer made it possible. Unfortunately now that I have the binary data and images available in my model I can't do anything with them:'( I want to use them like I can in Power View for Tile By and Datacards... Help!!!

Comments (37)
Dan English's profile image Profile Picture

Power BI User on 05 Jul 2020 22:16:17

RE: Data Model Image (Binary) Support in Reports

Not on my own, I also have the same issue with loading binary in power bi specifically for the new chiclet slicer. help please...

Dan English's profile image Profile Picture

Ivan Bondarenko on 05 Jul 2020 22:15:31

RE: Data Model Image (Binary) Support in Reports

Loaded colleague's thumbnailphoto from Active Directory as binary images to data model but couldn't find way to visualize them

Dan English's profile image Profile Picture

Ted Murphy on 05 Jul 2020 22:08:37

RE: Data Model Image (Binary) Support in Reports

The new Chiclet Slicer is really impressive ... but you need to be able to load the Binary files to the Data Model!

Dan English's profile image Profile Picture

José on 05 Jul 2020 22:02:44

RE: Data Model Image (Binary) Support in Reports

In dashboards, would be very useful to filter by an item (country, employee) and obtain a specific image (flag, employee id photo).

Dan English's profile image Profile Picture

Mani on 05 Jul 2020 22:02:17

RE: Data Model Image (Binary) Support in Reports

I am still struggling. I have created sample Table with Varcbinary(max) data type also Image data type in table. Load images in that table but when i attached to power query pic not shown just show Binary. can you please help me on this matter.

Dan English's profile image Profile Picture

Kyle Harwood on 05 Jul 2020 22:01:45

RE: Data Model Image (Binary) Support in Reports

Ability to upload pictures into Excel or PowerBI without having to pull them in from SQL Server. Also, ability to point to any SharePoint list and display pictures in PowerBI. Also point to pictures stored in SharePoint list. Pictures greatly enhance the user experience and their should be an easier way to get pictures into the Excel and PowerBI.

Dan English's profile image Profile Picture

Janet Humphreys on 05 Jul 2020 22:01:10

RE: Data Model Image (Binary) Support in Reports

Add images to data models and use in powerBI designer for tiling etc,