How to Publish series of pictures in PBI

[AnilLom2022]

Dear PBI Experts,

Please can you help me?

I have lots of pictures taken from site to show progress. However, I am finding it difficulty to dig out historical pics. I was wondering if there is any way in PBI this can be achieved. What I mean is, if I have a date slicer, upon selecting a date, I want a table showing pictures of the site. Is this something can be achieved?

Anil

[v-jianboli-msft · Accepted solution]

Hi @AnilLom2022 ,

You can't use the share link of OneDrive Directly. You can use the embed function in OneDrive to get embed code.

If you are using OneDrive for Business, it does not support embed function. You can get the image url by using the view original function.(Due to some reasons of sign in, this solution will not works perfectly in some condition)

Some alternatives that you can try are:

• opening an account in a picture hosting site, such imgur. That should give you enough privacy for the pictures hosted there.
• store the images in other systems that can generate a usable direct link (i.e: begin with https://— and end with the image type PNG, JPG, JPEG, or GIF) for instance a CRM (Hubspot will work for sure)
• store the images in your company's website (I have tried this with Content Mangement Systems such Wordpress, in the media folder of the website you can store the pictures and use them without necessarily publishing on any webpage)
• check if your company is using any other system or online storage solution that generates a direct link for the pictures saved in it.

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AnilLom2022]

Dear Jianbo Li,

Thank you very much for providing solution. I've uploaded pics in One-Drive and not able to generate Embed code for the image. Do you know why? I dont see any options. I've tried with one drive link, its not working

[v-jianboli-msft]

Hi @AnilLom2022 ,

Based on your descriptions, I have created a simple sample:

First, change the data type of url to Image URL

Then apply it to the table visual:

Create a slicer of date:

Final output:

Refer to: Display images in a table or matrix in a report - Power BI | Microsoft Learn

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.