Forum Discussion
RajaSadagopan
2 years agoRegular Visitor
Dynamic RLS with embedding
Hi, So I have embedded a powerbi report in another web application. To view the report, user needs to login. Now the report has data for all departments. But the logging in user belongs to some sp...
- 2 years ago
RLS must control the data model. It needs to be applied to a dimension table on the outside of the star schema.
RajaSadagopan
2 years agoRegular Visitor
No we have not applied RLS to dim table! The username in fact_user is the username used to login to the web application. The username is linked to department via department ID
- lbendlin2 years ago
Super User
RLS must control the data model. It needs to be applied to a dimension table on the outside of the star schema.
- RajaSadagopan2 years agoRegular Visitor
Thanksss Bro ❤️