Implement Roles in a SSAS Tabular Cube

Roles in tabular models define member permissions for a model. Members of the role can perform actions on the model as defined by the role permission. Roles defined with read permissions can also provide additional security at the row-level by using row-level filters.
In this video we will review how to add roles to your tabular model project using the Role Manager in Visual Studio.
►► The Starter Guide for The Modern Data Stack (Free PDF)
Simplify the “modern” data stack + better understand common tools & components → bit.ly/starter-mds
Timestamps:
0:00 - Intro
0:11 Adding Roles in SSMS
0:43 Accessing the Role Manager
1:25 Create a New Role
4:01 Review Results
5:15 Testing More Changes
6:19 Closing
Title & Tags:
Using Roles in a Tabular Cube | SQL Server Analysis Services (SSAS) Tutorial
#kahandatasolutions #ssas #dataengineering

[@KahanDataSolutions]

►► The Starter Guide for The Modern Data Stack (Free PDF)→ bit.ly/starter-mds
Simplify “modern” architectures + better understand common tools & components

[@komanguy]

Thanks a lot! Very well explained!

[@anurag4862]

Thanks a lot. Very helpful and well explained

[@syedislam3019]

Great content! Would like to see more advanced SSAS tutorials on Tabular models, Real time scenarios, troubleshooting etc. I enjoyed the bite size tutorials! Thanks!

[@KahanDataSolutions]

Noted - Thanks for watching!

[@hellmutmatheus2626]

thank you very much!

[@udaythakur1405]

Superb SSAS quick learning & recap videos.. 🙏🏻🤝

[@CaribouDataScience]

Do you need to have a database login to use SSAS?

[@looklook6075]

it would be useful if we can update the role in analysis service sever through a job because the roles in my case changes everyweek

[@misiael88]

Is it possible to set cube-level permissions for tabular models? I can't see the "Cube" pane in roles wizard..

[@moulabeenetturi8758]

i have created one role level security but i am getting rows which should not ...please suggest me.. i am using visual studio 2019