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.

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

    47 comments

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