Forum Discussion

Pramod's avatar
Pramod
New Member
10 years ago

Row level Security not working with SSAS Tabular DB - Need Help

Hi All,   I followed the step provided in some other blog to implement SSAS Tabular DB Row level security, but its not working. Can someone please help. Below are the steps I followed   1. Create...
Need Help
austinsense's avatar
austinsense
Icon for Impactful Individual rankImpactful Individual
10 years ago

My immediate questions are

 

1. How do you know that it's not working?

2. Did you setup the DAX in the roles correctly?

3. Did you setup the usernames in the roles correctly?

    • Pramod's avatar
      Pramod
      New Member
      10 years ago

      Austine, Most of the vedios are referring to PowerBI Analytics Service Connector, but I believe its not available anymore right?

      I have setup PowerBI Enterprise Gateway, which should do same right?

       

      Mind that I am able to connect and query the SSAS tabular DB, its only that the roles are not working as expected, even after setting a role for a specific user he is able to see all data.

       

      • v-sihou-msft's avatar
        v-sihou-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        10 years ago

        Pramod

        In Power BI, all security set in data source will not be taken. To limit the access, you have to set the Row-Level Security(RLS) on Power BI Service, you can add those users as membership and apply DAX filters. It's similar to Tabular Row-Level Security. Just click the ellipsis of dataset, select "SECURITY".

         

         

        Reference:
        Row-level security

         

        Regards,

  • Pramod's avatar
    Pramod
    New Member
    10 years ago

    Hi Austine, Thanks for your reponse.

     

    Yes, I believe I have provided correct DAX statement, which is =R_Acquire[country]="AT" for AT Only Role.

    UserName was added using entire directory option.