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)
RE: Data Model Image (Binary) Support in Reports
I need to give the report on the unique Id in a Database table, currently it is not possible
RE: Data Model Image (Binary) Support in Reports
Need this for binary Type from Blob Storage
RE: Data Model Image (Binary) Support in Reports
Need this to get data from SharePoint Folder and extract the files :)
RE: Data Model Image (Binary) Support in Reports
we need this feature in live connection for binary type images
RE: Data Model Image (Binary) Support in Reports
up
RE: Data Model Image (Binary) Support in Reports
Very lame that this isn't supported in Power BI
RE: Data Model Image (Binary) Support in Reports
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.
RE: Data Model Image (Binary) Support in Reports
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.
RE: Data Model Image (Binary) Support in Reports
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!
RE: Data Model Image (Binary) Support in Reports
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!