Hello all,
In my pbix file I have multiple fact tables seaparated into different models with some common and unique dimensions connecting to each of them.
Essentially, I have a core role level security table that will filter the report accordingly for all of the models I attach it to. However, one of these fact tables is Staff/HR related which needs to have tighter security than the rest of the models. So, for someone who could see lets say, 10 accounts on one page, they might only be able to see 4 accounts on the staff page or even not see any data at all.
Ideally, this staff RLS table would be different than the other RLS table with the rules defined back in the source so that it behaves as expected, separate from the other pages with the standard RLS model attached. Then, a user could be attached to multiple roles where one of the roles is used on the staff page while the other role is used on the rest of the report.
However, I was reading that putting a user in multiple roles with different access levels can cause unexpected results... is this true?
If so, how would it be best to handle this situation? I'm trying currently to somehow combine the 2 RLS tables back in the data but that is proving tricky. Separating the staff section into its own pbix isn't really an option as we're wanting one single report for all different segments of the company.
Any help is much appreciated and I can gladly provide more clarity as needed.
Thanks!
