Multiple versions of the same report in different TEAMs audiences

[khenning]

I'm main Power BI reports Developer and Admin in our company.  I create the reports in Desktop, upload them to the cloud, and then our users view them within TEAMs.  We have audiences based on what department the users are in so they don't see the reports that don't pertain to them.  I want to have the same report file in different audiences, each with their own filtered version of the report.  Is this possible?

TIA!

Kris 

[tayloramy · Accepted solution]

Hi @khenning, 

This is possible with RLS. 

see Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn and Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn

The hard part is determining what department the user is in. Do you have AD groups or similar to determine this? 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution. 

[AnalyticPulse · Accepted solution]

hi,
@khenning 
If you want to keep one version of the report but filter data automatically based on who’s viewing it, use Row-Level Security
you can define role like : [Department] IN LOOKUPTABLE(Departments[UserEmail]).
Publish the report and assign users or groups to each role in the Power BI Service.

you can test the roles in desktop app itself.
this will serve your purpose. you dont have any extra maintenance with this approach.

My Work:
Analytic Pulse Blog 
Docynx Productivity Tools 

[khenning]

Thank you!  I got it to work!

[tayloramy · Accepted solution]

Hi @khenning, 

This is possible with RLS. 

see Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn and Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn

The hard part is determining what department the user is in. Do you have AD groups or similar to determine this? 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution. 

[khenning]

Thank you!  I got this to work in a test.