Forum Discussion

Brettp761's avatar
Brettp761
Icon for Advocate II rankAdvocate II
10 years ago

Role-Based Default Filter Context

Hi,   I've written a technical paper on implementing role-based default filter contexts in SSAS Tabular, Power BI, and Power Pivot models and made this available for download:   Default Filter Co...
Tips and Tricks
jadhav_vilas84's avatar
jadhav_vilas84
Icon for Advocate II rankAdvocate II
9 years ago
Hi , I had create role ...from manage role using table role master on base role_ID base , it is working fine on test as role . I had added some users email id for this role. but when I login with these users... dashboard report data or in report data is not dynamically filter. Please help for how to apply row level security using power Bi desktop application. thanks vilas jadhav
Brettp761's avatar
Brettp761
Icon for Advocate II rankAdvocate II
9 years ago

Reza Rad wrote two very good blog posts on applying row level security in PBI Desktop including dynamic RLS:

 

http://radacad.com/row-level-security-configuration-in-power-bi-desktop

 

http://radacad.com/dynamic-row-level-security-with-power-bi-made-simple

 

For PBIX models deployed to PBI Service (not on-premises SSAS instances) be aware of USERPRINCIPALNAME() and differences with USERNAME() per following post:

 

http://prologika.com/new-userprincipalname-dax-function/