cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
krajani Member
Member

Re: RLS design & DAX rule suggestions

Hi Matt,

 

 

I would prefer a dynamic solution as my original report has 80 users, and I know that some of the other solutions that I am working on, have multiple groups and over 200 users, at variuos levels. This translates into a considerable chunk of maintenance work which I'd like to avoid, unless it could be automated. You reckon there's a way using PowerShell, or anyother mechanism, that we can automate the synchronisation of the the groups? 

 

As far as having one group per BU goes, as I want users associated to multiple BUs, be able to look at all of their BUs, I have created one single group with a DAX evaluating multiple BUs, effectively BU=1 || BU=2

 

Thanks
Kaz

Highlighted
Super User
Super User

Re: RLS design & DAX rule suggestions

Sorry, I've been busy. It seems to me that you have the data somewhere, so I assume this can be loaded into the data model. I would be then looking to leverage the username() function to give access or not. But you would need to test it of course. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
krajani Member
Member

Re: RLS design & DAX rule suggestions

Thanks for getting back to me @MattAllington, I have rolled the solution out for UAT. I have leveraged UserName() DAX function and it works.

 

I was referring to adding indivual member in the list of users under Datasets > Security. 

 

Thanks

 

Kaz

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 208 members 1,792 guests
Please welcome our newest community members: