Forum Discussion

nrichards_au's avatar
nrichards_au
Helper I
1 year ago
Solved

Row Level Security exclusions

I don't think it's possible but I'm putting it out there.   I've got a fact table that has RLS against the DEPT ID field. I was wondering if it's at all possible to exclude RLS against the particul...
Data Protection
  • nrichards_au's avatar
    nrichards_au
    1 year ago

    Thanks everyone for the responses.

    It wasn't that I didn't know how to create a solution more wondering if RLS could be ignored against a particular column in spite of it being against the nature of RLS.

     

    I'm dealing with fact tables of about 500M rows so wanted to limit duplicate aggregation tables if possible but don't think it is possible

MarkLaf's avatar
MarkLaf
Super User
1 year ago

You need to duplicate the column in a calculated table that doesn't get filtered by RLS. If not entirely applicable to your scenario, this SQLBI article walks through the general pattern: https://www.sqlbi.com/articles/computing-accurate-percentages-with-row-level-security-in-power-bi/

 

Is there a particular calculation you need to achieve? To provide more help, I think we'd need a little bit more context related to your model incl dummy data + desired output you want.