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

398 votes
Sign in
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

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


Sign in
Sign in with: Facebook Google
Signed in as (Sign out)
  • Michael Bernier commented  ·   ·  Flag as inappropriate

    So, this idea has been posted here since March of 2015 and no response yet? We have images embedded in tables that we'd like to use, but we have to pull them out and put them on a separate web server in order to use them? That's worse than ridiculous. C'mon, Microsoft, you're better than this.

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

← Previous 1

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.