Forum Discussion
Power Bi app audience
Hi everyone,
I have a Power BI app with multiple audiences. I understand that audiences are mainly for controlling visibility and permissions (who sees which reports/dashboards).
What I’d like to achieve is to have different default filter selections for each audience. For example:
Audience A sees the report with Region = US applied
Audience B sees the report with Region = Europe applied
From what I know, audiences don’t support this directly, and RLS applies an OR logic if a user is assigned to multiple roles, so it doesn’t solve my use case when the same person is in both audiences.
My question:
Has anyone found a workaround or best practice to achieve different filtered default views per audience without duplicating and maintaining separate reports? So Audience A page will show US data and Audience B page will show Europe data, even if you have both roles applied over your account.
Thanks in advance for any ideas!
Hi SilviuBratila,
I think the best way to do this is unfortuneately to maintain different reports, or different copies of the same report sitting on filtered views.Just thinking out loud, you can add URLs as items in the app, and in a report URL you can apply filters as parameters, so You could in theory add the same report to different audiences with a different filtered URL.
However this doesn't prevent the users from removing the filters, so they would still be able to access all data. SO this is not a good solution if data security is the goal here.
Filter a report using query string parameters in the URL - Power BI | Microsoft LearnOutside of this, I wonder if you could do some shenangians with RLS and views - but if you have a user with multiple roles you would end up in the same spot where the OR logic is applied.
If you found this useful, consider giving Kudos. If I solved your problem, mark this post as the solution.
3 Replies
Hi SilviuBratila,
I think the best way to do this is unfortuneately to maintain different reports, or different copies of the same report sitting on filtered views.Just thinking out loud, you can add URLs as items in the app, and in a report URL you can apply filters as parameters, so You could in theory add the same report to different audiences with a different filtered URL.
However this doesn't prevent the users from removing the filters, so they would still be able to access all data. SO this is not a good solution if data security is the goal here.
Filter a report using query string parameters in the URL - Power BI | Microsoft LearnOutside of this, I wonder if you could do some shenangians with RLS and views - but if you have a user with multiple roles you would end up in the same spot where the OR logic is applied.
If you found this useful, consider giving Kudos. If I solved your problem, mark this post as the solution.
Why not just apply a filter to each of the reports and then link those reports to the audiences? Yes, you would still have multiple reports, but it would be as simple as a filter?
Thank you for submitting your question to the Microsoft Fabric Community Forum, and thanks to tayloramy and GilbertQ for offering helpful suggestions.
Could you let us know if the suggested solution resolved your issue?If you still need help, please share more details so we can assist you further.
Thank you.
