Forum Discussion

Blues88's avatar
Blues88
Helper I
4 years ago
Solved

Power BI as Search Engine for Photo Catalog

Hello,   I need to create a catalog for photos of company vehicles. I'd like to use Power BI as a search engine for the photos as well as a report for metrics regarding the photos (ex. time since l...
  • Blues88's avatar
    4 years ago

    I connected my Power BI report to SharePoint where my photos are saved. 

     

    Then I created a custom column in Power Query named "Image URL" and combined the fields "Folder Path" and "Name" like so:

      =[Folder Path] & [Name]

     

    Then I closed and applied.

     

    I clicked on my newly created "Image URL" field and chose "Image URL" from the drop-down menu called "Data category" in the properties section. 

     

    I downloaded the "Simple Image" visual from the "Get more visuals" section and added my "Image URL" field to it. 

     

    My matrix includes the original field called "Name", which is tied to the corresponding image from the "Image URL" field I created. So when I click on an image name in my matrix, the "Simple Image" visual updates with the corresponding photo.

     

    FYI, you will only see the images in the visual in a published version of the report. In the desktop version, the "Simple Image" visual will appear blank.

     

    Let me know if you have questions.