Skip to main content

Power BI

Needs Votes

Data Model Image (Binary) Support in Reports

Vote (486) 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 (29)
Dan English's profile image Profile Picture

cbbe410d 30eb-419e-b76b-98853d4f75d7 on 05 Jul 2020 22:20:44

RE: Data Model Image (Binary) Support in Reports

With the addition now of exporting the file as a template, it's very important to be able to access image files to update them automatically on each page (e.g., a logo file that can be changed for various companies/departments, etc.)

Dan English's profile image Profile Picture

813f701c bf39-43df-8caf-7209182403b1 on 05 Jul 2020 22:19:15

RE: Data Model Image (Binary) Support in Reports

Totally agree. People are VISUAL, after all, that's why we're creating VISUALizations. So why can't we use an image in Power BI Desktop? How about it Design team? It's been a year since this item has gone up and no comment? Can't believe it doesn't have more votes.

Dan English's profile image Profile Picture

14ced85e 3445-42ee-8e5c-3a1549bd5a4a 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

23309802 5327-4608-9a85-757be45ca59b 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

133f1aaf 17aa-40bf-96b7-7cf2e415e4aa 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

3ae24326 5627-4291-a011-8646fb4a1fb3 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

aa684c48 9647-4a8d-b536-02194e7d47ae 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

db251c61 de7c-48ec-9ef9-dc02bb7a581f 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

b2679a4b 7ed2-4226-90f0-5de99a9c7efc 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,