Forum Discussion
How to Include images in reports from folder or url or binary data in Power BI Desktop
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.
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...
Sorry I dont understand... The data is not stored as binary in excel... It is just text in a column which is a url to the photo on an external website. If i flag a binary i get an error.
Is there anyway to use an image from a website with a url pointing to the image?
Oh yeah, that is way easier:
When you said you were getting them from a folder, I assumed you had them locally or something and were bringing them in as binary.
I was able to get this far by having the image show via a URL in Excel "Power View" The data is in the powerview data model but when i import the data into Power BI Desktop i dont see the data model from Power View to select, Does Power BI Desktop support getting data from a Power View Data Model?
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.