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.

983 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    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
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      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.