Forum Discussion
Power Bi app audience
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.
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 Learn
Outside 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.