Slicer Issue while RLS enabled user logins

Anonymous · ‎08-26-2020

Hi team,

I have a report for which RLS is enabled for users.

Account	User
1	1
1	2
1	3
2	4
2	5
3	6

We have a report with single select slicer for account, Lets say this report is published to Power Bi service with Account-1 selected suppose if user 4 logins first time he would see Account 1 for which no record shows ( because of cache).

Is there a way that all these first time users will see only there records in Account slicer in Power BI service.

Greg_Deckler · ‎08-26-2020

@Anonymous - Perhaps https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Hierarchical-Row-Level-Security/m-p/889567#M406

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

amitchandak · ‎08-26-2020

@Anonymous , slicer initialization is an issue.

See if this can work. You can have a column like this and select the current user. Not RLS of slicer need to take care of

if([user] =useprincipalname() ,"Current Uset", [User] & "")

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Anonymous · ‎08-26-2020

OK but then i have some set of super users who have access to all the data. Below approach is just for RLS

Anonymous · ‎08-31-2020

Hi @Anonymous,

You can also take a look at gateway SSO options that allow using end-users' credentials to interact with data sources if your data source in the support data sources list.

Overview of single sign-on (SSO) for gateways in Power BI

Configure Kerberos-based SSO from Power BI service to on-premises data sources

Regards,
Xiaoxin Sheng