Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Solved! Go to Solution.
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.
Proud to be a Super User!
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.
Proud to be a Super User!
I feel like an idiot for not trying that. Thanks!
User | Count |
---|---|
103 | |
87 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |