Not able to display userprinciplename() data

[Anonymous]

Hi All,

I am not able to get user login data by using USERPRINCIPALNAME() when i save and publish the report in PowerBi Services it display all data but my requirement is to display for example when i login the report from my id records will display along with my name and data but i am not getting exact records,it display all records ,could you please suggest me 

[Anonymous]

@Greg_Deckler i  had applied realation b/w sheet1 and sheet2 tables and i am the login with power bi workspace with company id 

[Greg_Deckler]

@Anonymous So, is the login you are using a Member of the workspace? If it is, then RLS will not apply and you will see everything.

[Greg_Deckler]

@Anonymous Hard to say exactly. Where is the data coming from in the table visual? Is there a relationship between Sheet2 and Sheet1? Remember that if you are a member of the workspace, RLS does not apply.

[Anonymous]

@Greg_Deckler i joined the link b/w Sheet 1 and sheet2 

[Greg_Deckler]

@Anonymous Yes, that is correct. What I am saying that even with that relationship and the RLS rule, if you are a member of the Workspace where the report is published then RLS will not apply and you will see everything.