Dynamic row-level security for Power BI Report Server
Power BI Desktop (optimized for Report Server) allows you to define roles with DAX filters. However, when reports are published to the Report Server, there is no way to assign these roles to specific users/groups, so we can't yet implement row-level security on the Report Server. It would be great it Report Server was able to support dynamic row-level security similar to the Power BI Service.
We shipped this support in the January 2019 version of Power BI Report Server, which you can download here – https://aka.ms/pbireportserver
Thanks so much for all your votes on this idea!
Luis Higueros commented
@chrisFinlan - Any way we can have a default where we don't to assign a role as Annie commented below. We can programmatically add the users, but can we just have the DAX filter make the decision based on what is on a 'user' table like we do in dynamic RLS on SSAS models?
This is not really the same as how it works in the cloud. You have to go through and assign *every single user* to a security role. In my organization, I just want it to apply to all users who look at the report. I can't assign thousands of people to security groups.
Hello, do you have a date in mind? I need this capability for a big international project which will be released in less than six months.
Thanks great news, but when???
Thomas Walker commented
@ChrisFinlan When is the next updated planned roughly? Thanks!
is there any plan to add RLS on Power BI report server on next update
It would be great if PowerBI could simply use RLS implemented on a database level
Excellent News! :-)
Shane Wu commented
YAY! Thanks Chris!
Ariel Levy commented
Hi Riccardo! I set the variable USERNAME() in the role, but aparently is not only a gap for asigning users to roles, but the role DAX engine is not working at all right now. The USERNAME() in report server returns the current user
is too long ...
Would be waiting for this @Riccardo Multi...
2. Within your Power BI report. You can define the roles and filters in Power BI Desktop, but can’t yet assign users/groups to these roles in Power BI Report Server. Rest assured we plan to address this gap as soon as we can. We don’t yet have a timeframe to share, but can update you again when we’re able to start this w
Víctor M. García commented
Hello @Riccardo Muti, are there any update on this idea implementation? Customers rolling out PBI RS are increasingly asking for it
Yes, this feature is urgently needed!!!
yes this is a important feature for many companies. if this is not available we will have to use Tableau which have the feature in their service version
Steve Yeung commented
When will this be implemented?
Hi! is there any updates regarding RLS in Power BI Report Server?
Team, Any update regarding the RLS in Power BI Report Server features
LD TM commented
Hi. Do you have any news about RLS in power bi Report Server ?
My clients are waiting for it for some reports I've made with import datas.
Hope this feature will be available soon!