Forum Discussion
User refresh on PBI Service
Currently I receive an image each week and I replace the image in the report. If the user was to go back and check the history, this cant be done as the image is the latest one. Is there a way for an image to be dynamically updated in the report as I need the Week Commencing field and the image for that week. I did think about creating an excel file with 2 columns - wc and image but dont think this can be done. I am open to any solutions you have?
It depends on how you are embedding the image - but if you're embedding it in, say, a table, you can use the "image URL" category in your datasource for that column in a table to display it as an image. Again, for SharePoint images, this won't work in the desktop, but you can see them when published (I publish to my personal workspace first to verify they work).
You can just straight-up upload and replace the image each time to a SharePoint library, then the scheduled refresh will pick it up. You can access the image path a number of ways, I prefer OData to get the file path. I did a tutorial on how to do this for hyperlinks, the process would be the exact same for an image except you'd just choose "image url" as the data category for the column (obviously filter the query down to just the one file you want to display): https://youtu.be/yeIQ9jKln_I?si=EaiTpbu7IEWAPPJf
Here's the dropdown to do that: