How do I insert images from a website into Power BI?

[ironryan77]

I want to use Get Data in order to insert images from a website into Power BI.  How do I do this?  Alternatively, I could insert images into a SQL table, but we don't have write access for BULK Inserts, so it would have to be a different way.  How else?

[tjd]

I don't believe that you can store the image within the PowerBI model.  However, you can store the website url for each image in a table in PowerBI.

[ironryan77]

Thank you.  What I'm trying to do is to add a URL from Bing Images, where it will display all of the different images from one screen into separate rows.

[tjd]

Sounds good, but be careful when using someone else's website as they could change their url and break your data.

[ironryan77]

Unfortunately this doesn't work either because it only inserts the HTML table elements, not images.

[tjd · Accepted solution]

I would imagine that you need the url in the form "http://www.bing.com/images/something.jpg" or something similar.  Then, you need to declare the column as a url.  Finally, to use it in PowerBI, you would use the image url data box on the visual (e.g., Chiclet Slicer, or something).