Forum Discussion
How to Include images in reports from folder or url or binary data in Power BI Desktop
In the Financial Analysis Sample there is the ability to filter District Monthly Sales based on Selecting the photo of the District Manager.
I am trying to do the same, However i cannot add photos to the report in Power BI Desktop. I "Got Data" from a folder containing 10 photos. Set the binary field as "binary" but that column dissapears and is not available to the report.
What is the easiest way to use photos from a folder or as binary data in excel or sql to include in reports to enable me to use it as was done in the Financial Analysis Sample?
Ok I solved it... I think. At this time i believe that there is a limitation with both Power BI Desktop and the Online Version in working with both Binary Images and Images from URLs.
However if i design it in Excel 2013 using the Power View module and have the Images display in a Power View Report then I can Get Data using the Power BI Online version and the photos and data will show online in the "Classic Report Canvas". It does not work in the "New Power BI Report Canvas"
It also at this time does not work in Power BI Desktop.
Someone can correct me if I am wrong.
16 Replies
I'm seeing the same thing in Desktop. The minute you flag the field as Binary in the query, it disappears from the import and isn't available in the model or the report. Weird. If you do not specifically flag it as Binary in the query, then it appears in the data model but is the big long hex string.
You may have better luck in Excel:
Although a previous topic I was on we were getting little grey picture icons instead of the actual images.
I have it in excel as a url "http://bidemo.digitalsvr.com/colfireimages/10001.jpg" however it just appears as text http://bidemo.digitalsvr.com/colfireimages/10001.jpg in the Power BI Report and not as an image. Is there anyway to include it as an image?
In your Power Query in Excel, flag it as Binary while editing the query, BEFORE it gets into the data model. Then it should show up as "Binary Data" in the data model. Once that happens, you can set the Data Category to "Image". Let me know if you get the grey photo icons...
Could you please provide a link to the sample mentioned?
I've also been looking into how to include images, but without success. I saw your last post though, but I'm still interested in the sample mentioned.gusly This functionality is now included in the desktop. 1) make sure you download the latest version. 2) adding an image can be done from the toolbar in the PBI Desktop
Thanks, but that's only for static images, right? I'm looking for data-bound images.
I think the same goes for the creator of this topic, but again I haven't seen the sample he/she is referencing so I'm not sure.
