Forum Discussion
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. 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?
5 Replies
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?
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 !
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.
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.
