Forum Discussion
RLS with multiple fact tables
HI All,
I have a model where i am suppose to apply a row level security.
I have 3 fact tables which belongs to Enterprise and 3 other fact tables which belongs to other Wholesale and they both are linked to 3 dimensions havings one to many relationship to each other
I have to apply the RLS in such a way that when any user belonging to Enterprise views the report he would onlt be able to see the Enterprise Page and the Wholesale user would be able to see only Wholesale data(as i have 2 pages in my report)
I created two roles one for Enterprise and one for Wholesale and each of the roles i added the filter of Wholesale and Enterprise based on the table to which they belongs to and provided access to one user each for those roles respectively.
But I am unable to filter those users out and they are able to see both the pages
Note:My DIm_Role to Fact tables relationship in one to many with single directional as i am unable to set it as Bidirectional
Please help me and let me know how i could achieve this scenerio
1 Reply
- amitchandak
Super User
Anonymous ,
refer if this can help
https://community.powerbi.com/t5/Desktop/Option-for-user-to-hide-and-display-tabs-pages/m-p/711062
https://community.powerbi.com/t5/Report-Server/Hide-reports-or-pages-to-users/td-p/762740Row Level security
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns-in-Power/td-p/712613
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
https://blog.tallan.com/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/
