Forum Discussion
Power BI as Search Engine for Photo Catalog
- 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.
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.