SSAS Tabular Model Row Level Security Implementation (DAX Script) - 15 SQL Server Analysis Services

preview_player
Показать описание
SSAS Tabular model security can be implemented using SQL Server Management studio. We need to create a Role and then assign users to that role. After creating a role, we need to restrict data in the table in the form of rows using the DAX script.
We can create test users in windows using the control panel and then add users.
Row-level security is very powerful to protect unauthorized access to the data. For complete courses, you can buy these courses from Udemy on discount using the following links

Skillshare users can follow me on Skillshare for all the courses!
Рекомендации по теме
Комментарии
Автор

hello and thank you. I tried it but it is not working with username() in excel. if I use abc\1234 it is working but it does not work dynamic. any advice? (excel 2010)

osmana