How can we improve Power BI?

Data Model Image (Binary) Support in Reports

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!!!

243 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Dan English shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    20 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Jayesh Fulsundar commented  ·   ·  Flag as inappropriate

        I found solution to this problem

        Just select the column that is having binary data in query editer and click right >> transform >> text and it is done. click close and apply you will be able to see the column with appropriate text, which otherwise was not available to see in table view.

      • Mike Donnellan commented  ·   ·  Flag as inappropriate

        We also have cases where primary keys are of type varbinary(20). It would be very helpful to be able to use these automatically-generated primary keys (hash keys). Thanks!

      • George commented  ·   ·  Flag as inappropriate

        All my primary keys in my SQL DB are binary so although I can load individual tables I cannot create relations between them. It would be great if I could load the binary keys in PowerBI so I can relate different tables!

      • Kate commented  ·   ·  Flag as inappropriate

        Yes, I'm doing a proof of concept which involves picking and displaying images in multiple layouts and using different filter criteria.

      • Chris commented  ·   ·  Flag as inappropriate

        Agree. Ability to load binary and define ‘open with’ program to serve up files stored in Sql blob. PDF specifically is my need.

      • Jochen commented  ·   ·  Flag as inappropriate

        agree! Referencing Images from a anonymous webserver via URL is one Thing, aber loading "secured" Image which Needs authenfication or even better loading Images from binary data which is available in the model would allow much more advanced scenarios

      • Anonymous commented  ·   ·  Flag as inappropriate

        This is just nuts.... Every client that I have wants to see a red, yellow or green dot somewhere to report project health and though I can consume an image into Power Query I can't display it in a dashboard. How can something as simple as this not be part of the puzzle.

      • Koen Verbeeck commented  ·   ·  Flag as inappropriate

        It would also be nice if you could use binary data from SQL Server or SSAS (MD or Tabular) using Live connections.

      • TJ Doherty commented  ·   ·  Flag as inappropriate

        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.)

      • Todd Chittenden commented  ·   ·  Flag as inappropriate

        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.

      • Anonymous commented  ·   ·  Flag as inappropriate

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

      • Ivan Bondarenko commented  ·   ·  Flag as inappropriate

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

      • Anonymous commented  ·   ·  Flag as inappropriate

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

      • José commented  ·   ·  Flag as inappropriate

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

      • Mani commented  ·   ·  Flag as inappropriate

        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.

      • Kyle Harwood commented  ·   ·  Flag as inappropriate

        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.

      • Jan commented  ·   ·  Flag as inappropriate

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

      Feedback and Knowledge Base

      Ready to get started?

      Try new features of Power BI today by signing up and learn more about our powerful suite of apps.