Slicer Issue while RLS enabled user logins

[Anonymous]

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]

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

[amitchandak]

@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] & "")

[Anonymous]

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

[Anonymous]

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