Filter report with RLS

[Anonymous]

Hello
Happy New Year 2021 and most importantly very good health for you and your loved ones.

I have a question.

I have a table that comes from AD with UPN and the name of the company (there are a lot of different (large group of companies).

I would like to do a sort via RLS which when the person connects that he only sees his company's data and not the others.
I did this with the userprincipal name, but I only see its data.

Thank you for your answers

[Anonymous]

Hi @Anonymous ,

Could you please provide some sample data(exclude sensitive data) in your model? Whether you have the table as below, and he only can see the data from Company A when account aax@123.com access to the report? 

Company	UPN
A	aa1@123.com
A	aa2@123.com
A	aa3@123.com
B	bb1@456.com
B	bb2@456.com
C	cc1@789.com
C	cc2@789.com
C	cc3@789.com
C	cc4@789.com

Best Regards

[Anonymous]

Hello @Anonymous , 

I will do. 

Thank you 

[aj1973]

Hi @Anonymous 

How are you deploying the RLS?

Did you follow these steps?

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

[Anonymous]

Helllo @aj1973 , 

Yes I try with his UPN but I dont get what I expect. 

My report have a lot of data from several entity and every entity have employees.

If an employee connect to the report, I want that he sees only the data from his entity and that only when he logged in.

[aj1973]

I am sorry what do you mean by "his UPN"?

Also it doesn't matter how much data the report has or the number of entities. What matters is how to manage the Roles and filters in your desktop

[Anonymous]

@aj1973 , 

I try to add a role test like this 

But I see only his own data and not the data of his entity

[aj1973]

Because you are not filtering his data! 

For example, in that same role "test" filter something from Produits Tables or any other table and try again.

Here is an example

Let me know