Forum Discussion

yaman123's avatar
yaman123
Post Partisan
2 years ago

Dynamic local images based on date filter

Hi, 

 

I am looking to add dynamic images to my power bi report which change according to what week is selected from the date slicer. 

 

The images are sent via email each week and saved into a sharepoint folder and renamed to the week commencing date ie 20240304 etc..

 

How do I connect power bi to the images to show correctly each week? 

 

TIA

 

Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi yaman123 

     

    This link can help:

    Complete Guide to Embed Images in Power BI Reports (Part I) (alphabold.com)

     

    It is worth noting that the SharePoint Online doesn’t allow to generate URLs with anonymous access. We need to provide authentication to get access to these images. We cannot see SharePoint images with URLs on Power BI Desktop. We have to publish a report on the Power BI service, and the user must be logged in to SharePoint before accessing this report to see images properly. If the user isn’t logged in with SharePoint, then images will not render even on a web browser.

     

    Here are some links for your reference:

    How to Show Pics in Power BI - Zebra BI

    Display images in a table, matrix, or slicer in a report - Power BI | Microsoft Learn

     

    Best Regards

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

    • yaman123's avatar
      yaman123
      Post Partisan
      2 years ago

      Hi Anonymous 

       

      this does not seem to work for me. The sharepoint site is a private site available to my organisation and the folder where the images are stored is in this site. How do i give PBI access to view these images? 

       

      Is there an alternative instead of using Sharepoint? If i save the images in a shared folder in the local drive? 

       

      Thanks