Show images from folder based on data records selected

[vmonu]

Good day all,

I have lots of images (say employees) in a folder (many of them)

Based on the data selected say Employee 1 , i want to show the image for that employee from the folder.

All the Slicers, Image viewer etc., shows only the Link for the folder but not the image 😞

If there is an alternative way just to show the file path for the image ..so the user can click and then the image shows up in separate window is also okay (like an explorerer file command).

How can i do that..

Thanks in advance for your help

Regards

MN

[vmonu]

Upon further research... i came to know that you can't display the image from the local folder becasue of the Auth issue...

Now the question is... Can you just show that IMAGE location as a link so it can be opened in Windows (like Explorer file command etc.,)

Thanks

MN

[v-xuding-msft]

Hi @vmonu ,

You could change data category to image URL in Power BI Desktop. Then it will show per image automatically.

Best Regards,

Xue Ding

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

[vmonu]

The problem is the image NOT in the url... It's in the local folder... (multiple images say employee photos_

So , unless it's not showing (based on what i read thru you and other posts)  unless i convert each of them.

Is there any other option say ( just give the folder path alone... say C:\local\employee1.jpg) and thereby the user clicking it opens an IE or webbrower to show the image... (like using the file command etc.,)

Thanks again for your help

MN

[v-xuding-msft · Accepted solution]

Hi @vmonu ,

There is a video that may help you. 

Import images in Power BI from local sources

Best Regards,

Xue Ding

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

[vmonu]

Thanks @v-xuding-msft . That's a good solution.

Is there another way to just open windows explorer from PBI ( as that way , i don't need to convert  to base64 images).

Also the reason is my images will all be in multiple subfolders based on dept, employee history etc., so if i can invoke showing windows explorer , then i can show the file path and the user can click it to see the images.

If that's not possible then i will have to live with this.

Best

MN

[v-xuding-msft]

Hi @vmonu ,

For now, we only can open  windows explorer when changing the data category of columns to URL. 

Best Regards,

Xue Ding

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