Forum Discussion

shanawazsheriff's avatar
shanawazsheriff
Frequent Visitor
7 years ago

Paginated reports row level security

Hi All, We have started using paginated reports within powerbi service recently. Our data source is Azure sql server. We are looking for a way to have row level security in paginated reports. The use...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi shanawazsheriff ,

Current RLS only works on report server or database side, you can't enable RLS on paginated report.

For your requirement, you can submit an idea for this requirement.

Regards,

Xiaoxin Sheng

chrisfin's avatar
chrisfin
Power BI Team
7 years ago

RLS is available if you're using Azure Analysis Services or Power BI datasets.  Azure SQL database will support RLS by the end of June

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Could you please advise if tehre has been any updates on the RLS for Azure SQL database ?

    • chrisfin's avatar
      chrisfin
      Power BI Team
      7 years ago

      You should see this supported via oAuth for Azure SQL db by the end of the week (or weekend).

      • Karthik_Ram's avatar
        Karthik_Ram
        Helper II
        5 years ago

        Is OAuth also supported for SQL databases? Not Azure SQL.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    If RLS is supported in Azure AS, why isn't supported in SSAS? (I presume we're talking about using RLS with Paginated Reports)

    • chrisfin's avatar
      chrisfin
      Power BI Team
      6 years ago

      Because of the gateway, essentially.  There's work we need to do to go and enable that and what we did for Azure AS couldn't be directly translated back to on-prem because of the Gateway work.  It's still planned, and you can use the technique outlined here to still enforce row-level permissions in an on-prem AS instance today - https://docs.microsoft.com/en-us/power-bi/guidance/report-paginated-data-retrieval

       

      Chris