Forum Discussion
RLS and userelationship
I have a fact table and two dimension table, one is name and other is date. I want to calculate the count of one person's data from two columns in fact table for a given month. I use active relationship from name dimension to fact and date dimension to fact for one of the two data. For second data I use inactive relationship.
Now when I use rls on name dimension, I get error for the measures I used inactive relationship. Please suggest a solution.
Show us your model and provide us some sample data and RLS details.
4 Replies
- KNP
Super User
Show us your model and provide us some sample data and RLS details.
Hi Lakshmanan94 ,
Have you had an opportunity to review the super user’s response? Could you please provide a sample dataset for reference?
Hi Lakshmanan94 ,
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
- Poojara_D12
Hi Lakshmanan94
RLS does not activate inactive relationships automatically.
Whenever RLS + USERELATIONSHIP are together, use manual filtering logic or bridge table modeling.If you'd like, share a simplified version of your table structure and measure and I can try to dive into it and help you as much as I can do.
