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

[Pramod]

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. Created a SSAS Tabular DB with only one table imported in it, created 3 roles for country specifc in it 1) US Only, 2) AT Only, 3) All other (see 1st screenshot)

2. Created a BI gateway to access above datasource (see 2nd screenshot)

3. Created a Powerbi report using SSAS option and selecting Live Connection.

4. Published uisng the gateway (i know it used gateway as it prompted me that the report is published using gateway.

I was expecting the row level authentication will be applicable as per the user logged it. But it didnt, all countries records are shown in the report.

Cansome please help me to know where I went wrong?

[austinsense]

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]

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.

[ashishrj]

@austinsense @Pramod Please find the link below for the webinar which we have conducted on SSAS Tabular security

https://www.youtube.com/watch?v=lCKD9adzHC4

I hope this should help !

[Pramod]

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]

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