Forum Discussion
Overriding row level security
I have an SSAS tabular model where I have implemented row level security the user (win account) do only access to sales for the company he or she belongs to this works fine but we also have the ...
Hi joakimfenno ,
So far, to my knowledge, your requirement could be realized currently, because your RLS set for the table's row, and your sales infomation is one table, the rule from RLS will apply to people.
The only solution I can think of is that you create a new table with only the sales column in it. now, you could create a measure with this column and add it to the table visual.
I create a example in Power BI Desktop, please refer the attached .pbix.
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
creating a separate table is an option but it will require storage of a lot of duplicate data which I want to avoid
