Repeated/wrong values affter applying RLS?

Anonymous · ‎08-25-2022

I have a model, with my fact and dimensions Contract and Customer:

I added a RLS (row level security) in the Contract table, and now I cannot see the splits of a given Contract by Customer.

(Of course I have read all access, so its not an access issue).

Why is this happening?

otravers · ‎08-25-2022

Can you share your RLS DAX expression? Is this happening in the service or desktop?

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

dcrosseto · ‎08-25-2022

Hi,

If you delete the RLS you can see the informations together, right? If true, I would guess there is something related to your DAX expression on the RLS, let's say you created an rule by name and the string is not matching with the table result.

Hope that helps.

Regards,

Douglas.