Forum Discussion
Row Level Security in Power BI Report Server
I think what you want is to have a slicer that shows only the sales territories that the logged-in user is allowed to see, that you want to do that by showing the sales territory in the slicer and filtering the slicer using the filterRLS measure. Problem is that you can't put a visual filter on a slicer.
There may be some kind of hack or workaround, but not one I'm aware of off hand. Best I can think of is instead of a slicer, having a table that lists all the sales territories and when the user clicks on a row in that table it filters everything else on the page.
Hi,
I applied the visual filter and it works but when the report is published in the report server, the end user has the filter pane that can use to cancel the filter applied for each visual.
Your idea is great but is there any way to avoid the end user to edit the filter from the front end report.
thank you for your help
Hey,
I'm not sure if you are aware of this recent post by Christopher Finlan that you can find here:
https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-release-timing-update/
Here it is stated that with next release of Power BI Report Server that is scheduled for January 2019, it will then support Row Level Security :-)
Regards,
Tom
Unfortunately not that I know of. That is a huge problem with this approach. It's more a Row Level Suggestion than actual Row Level Security - a convenient way to pre-filter a report for users, but not true security.
Hi,
Thank you for your reply, I was looking if there is a way to use a measure as report level filter or as slicer.
A slicer can be used in hidden page ans sync to be applied to all the report.
But I'm unable to find a way to use a measure as slicer.
