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
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
    Microsoft 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,