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.

871 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 →
    planned  ·  Riccardo Muti responded  · 

    Thanks for your feedback! Here’s a quick update.

    You can implement RLS at a couple of different layers:

    1. Within your data source. Some data sources, such as SQL Server database (2016+) and Analysis Services, have built-in support for RLS. Then, when you connect from Power BI Desktop in DirectQuery mode, you’ll see only the data you’re allowed to see. The same does work in Power BI Report Server if you configure it to delegate (Kerberos Constrained Delegation) or impersonate (“Log in using these credentials, but then try to impersonate…” checkbox) the user viewing the report.

    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 work.

    53 comments

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

      • Modestas commented  ·   ·  Flag as inappropriate

        @Riccardo Muti, any updates on the plan/timeframe/start of work on this improvement?

      • Alex Pixley commented  ·   ·  Flag as inappropriate

        Microsoft Dynamics AX's three Power BI content packs require RLS. Considering the type of client likely to run both Dynamics AX and Power BI Report Server, I would have expected this functionality to be available well before now.

      • Mrinal commented  ·   ·  Flag as inappropriate

        Please fix this about RLS implementation on power bi report server on urgent priority as many customers are demanding and moving to use power bi report

      • Sebastian Ross commented  ·   ·  Flag as inappropriate

        This is vital functionality for anybody working with 'sensitive' data.
        A very surprising omission in an otherwise comprehensive product offering.

      ← Previous 1 3

      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.