Forum Discussion
Solved
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...
RLS must control the data model. It needs to be applied to a dimension table on the outside of the star schema.
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
RLS must control the data model. It needs to be applied to a dimension table on the outside of the star schema.
Thanksss Bro ❤️