Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
drelourenco315
New Member

RLS- Same user for different filters/rules

Dear all,

 

In the desktop version, I inserted some rules regarding manage roles so that I have different views per country. For instance, If I want someone to see only Germany data, they'll only see that. 

 

As for the next step, after publishing it, I went to powerbi service and to the dataset security to define the RLS. Furthermore, I want the same people to see different countries. For example, I want roger to see both germany and france. However and despite having a RLS for Germany and another for France, when I put Roger's email in each of the RLS, Roger can only see Germany when he accesses the dashboard.

 

As such, I wonder:
a) whether I have to create a new rule in the manage roles, in which I filter for germany and france. If so, how can I do it?

 

b) if Roger is doing someting wrong or if it is a sort of a bug as I have inserted his email in each of the rules of the RLS and it should be working.

 

Thank you for the help!

2 REPLIES 2
GilbertQ
Super User
Super User

Hi @drelourenco315 

 

What happens if you just put Rodger into the France role does he only see France?

It could be something wrong with the France Role?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

NaveenGandhi
Super User
Super User

Hello @drelourenco315 

Can you confirm if you test it as role or with email id? Even if you have two seperate roles for german and france. Roger should see both countries. 

NaveenGandhi_0-1686069679778.png

Let me know if this helps!

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!



Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.