cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bknowles
Regular Visitor

RLS userPrincipalName OR Usage Program Tag

Hi.

 

I'm really prolific this week.  We're in the implementation stage of one project and the Development stage of another.  I'm the sole Developer/Administrator.

 

My first project was pretty standard.  This second one is a little more complex.  They want basic Active Directory userPrincipalName() RLS to apply except if the cost center in the Usage table has a particular Program Tag.  Our RLS security data is contained in a table called AccountGroupMapping and we link it via a dataflow to a table called PAS Group which contains the Active Directory Security group.  That in turn links to a table called person which contains the PAS Group and the userPrincipalName.

 

Currently, there's only one ProgramTag in the Usage table.  Eventually, there may be more, but there aren't expected to be a lot.  I do have a message out to the DB Developer/Architect confirming that the security for this will never be more complex because otherwise the hierarchy for this could be a nightmare and I'd need to map it all out.

 

I've attached a screenshot of  the data model for the pbix file, but I'd appreciate any ideas you might have for how to write the DAX expression for the roles.

 

bknowles_0-1632508814168.png

 

 

Thanks.

Barbara

 

2 REPLIES 2
v-xiaotang
Community Support
Community Support

Hi @bknowles 

Have you solved your problem? If yes,  could you kindly mark the answer helpful as the solution? 
If not, could you provide more details about your problem? so that we can work on it further. Thanks.


Best Regards,
Community Support Team _ Tang

v-xiaotang
Community Support
Community Support

Hi @bknowles 

I find a post similar, please check if it helps,

vxiaotang_2-1632737986090.png

https://community.powerbi.com/t5/Desktop/Dynamic-RLS/m-p/1931363

 

if you need more help, please @ me

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!