This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 46%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
Why is "Row Level Security" grayed out?
Where can I find official documentation about this? (if not official, is there a book?)
Is there any difference in putting the DAX code in the RLS in either the fact or the dimension? whats best practice?
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi @ovonemty
I'm sorry, but there isn't much official documentation about SSAS, and even less about Row Level Security.
I have encountered a case before, the client also had a problem in Row Level Security, he himself solved the Row Level Security gray out problem, you can refer to it. https://learn.microsoft.com/en-us/answers/questions/1148855/changing-cardinality-in-rls-makes-rls-only-work-if
In addition, you can also refer to the content of these two links.
https://www.kasperonbi.com/dynamic-security-made-easy-with-ssas-2016-and-power-bi/
Best regards,
Percy Tang
If the answer is the right solution, please click "Accept Answer". If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.