How can I display a Microsoft Teams user’s dynamic profile picture in Power BI without storing or re

[govind_021]

I want to implement a solution where, upon logging into Power BI, each user’s profile picture (as used in Microsoft Teams) is displayed dynamically. The key requirement is that I do not want to create any extra columns for image URLs, nor do I want to store image paths anywhere in the dataset. The profile picture should be fetched and shown dynamically, mirroring what users see in Teams.

Is there a way to achieve this in Power BI? If so, could you please share the steps or direct me to any resources or examples?

Thank you!

Best Regards
Govind Sapkade ( Microsoft Certified Data Analyst , PL 300 Certified , MS Fabric Enthusiast)
Let's Connect
Linkdin - www.linkedin.com/in/govind-sapkade-845104225
Youtube - http://www.youtube.com/@govind_dataanalyst

[v-priyankata]

Hi @govind_021 

Thank you for reaching out to the Microsoft Fabric Forum Community.

@danextian @jaineshp Thanks for the inputs.

I hope the information provided by users was helpful. If you still have questions, please don't hesitate to reach out to the community.

[v-priyankata]

Hi @govind_021 

I wanted to check if you had the opportunity to review the information provided by users. Please feel free to contact us if you have any further questions.

[v-priyankata]

Hi @govind_021 

Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.

[jaineshp]

Hey @v-priyankata,

Thank you for the kind recognition - always happy to contribute to our community's success!

Best Regards,
Jainesh Poojara | Power BI Developer

[danextian]

Power BI relies on the data in the semantic model so without a column for the image url or any image id and just create a measure that builds the url by concatenating the id with a text string, this isn't possible. However, you might be able to achieve a similar effect by embedding a PowerApps app that dynamically fetches the logged in users profile image. 

https://www.youtube.com/watch?v=1dEN3pObgQ0 

[jaineshp]

Hi @govind_021 ,

This is a good question, and it's something I've seen come up in a few scenarios. Here’s a brief breakdown of the options and limitations:

1. Power BI doesn’t support dynamic Teams profile pictures natively since images are behind Graph API and require user-level authentication.

2. Using Graph API via Power Query or a custom connector is possible, but it needs a gateway and would still store image data or URLs in your model.

3. Embedding the report in a Teams app or custom portal lets you load the profile image separately and display it outside Power BI.

4. A custom visual could work, but it would need separate authentication logic and custom development.

5. A practical workaround is to pre-load user images from Graph using Power Automate or a script, store them in a table, and map with USERPRINCIPALNAME() in DAX.

Let me know if you want help setting up any of these options.

Best Regards,
Jainesh Poojara | Power BI Developer