Forum Discussion

Don-Bot's avatar
Don-Bot
Helper V
2 years ago
Solved

An RLS expression filters this aggregation table but not the detail table which is not allowed

 

I am currently receiving this error message when I try to setup my aggregation table with RLS.  The infuriating part is I am getting this error when I try to setup the exact same RLS that is on the detail table on my aggregation table.  When I click the check mark I get this message and it doesn't work.  Is this some sort of bug?

My Fact table has this RLS:

[Company]=int(UserPrincipalName())
 
When I try to paste that into the aggregation table I get the below message.  Both tables have the same company field to make this possible.  
 

 

 

Need Help
  • DataInsights's avatar
    DataInsights
    2 years ago

    Don-Bot,

     

    Have you tried creating the RLS expression in the dimension table? For example, if your model has the table DimCompany and a relationship to each fact table, then you would create the RLS expression in DimCompany.

2 Replies

  • DataInsights's avatar
    DataInsights
    Super User
    2 years ago

    Don-Bot,

     

    Have you tried creating the RLS expression in the dimension table? For example, if your model has the table DimCompany and a relationship to each fact table, then you would create the RLS expression in DimCompany.

    • Don-Bot's avatar
      Don-Bot
      Helper V
      2 years ago

      I feel like an idiot for not trying that.  Thanks!