How can we improve Power BI?

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.

981 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Adam shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

67 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Annie commented  ·   ·  Flag as inappropriate

    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.

  • Emmanuel commented  ·   ·  Flag as inappropriate

    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.

  • shw5 commented  ·   ·  Flag as inappropriate

    is there any plan to add RLS on Power BI report server on next update

  • Mike commented  ·   ·  Flag as inappropriate

    It would be great if PowerBI could simply use RLS implemented on a database level

  • Ariel Levy commented  ·   ·  Flag as inappropriate

    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

  • Anonymous commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    Hello @Riccardo Muti, are there any update on this idea implementation? Customers rolling out PBI RS are increasingly asking for it
    Thanks!

  • Anonymous commented  ·   ·  Flag as inappropriate

    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

  • Serg commented  ·   ·  Flag as inappropriate

    Hi! is there any updates regarding RLS in Power BI Report Server?

  • LD TM commented  ·   ·  Flag as inappropriate

    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!

  • Stefano D'Ambrosio commented  ·   ·  Flag as inappropriate

    It is a very important feature. It is incredible that in server product like this one, with high targets (and costs), it has not yet been implemented.

← Previous 1 3 4

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.