Forum Discussion
Page Level Security with multiple fact tables
I have a requirement to implement Page Level Security in a report.
Since this feature is not available in Power BI, I am trying to achieve it with RLS but it is not working for multiple fact tables. Any suggestions to make this work?
PageA uses data only from TableA, PageB uses data only from PageB and so on.
| Users | PageAccess |
| UserA | PageA |
| UserB | PageA |
| UserB | PageB |
Thanks in advance
Rumi
2 Replies
- lbendlin
Super User
Abandon this attempt and use separate reports instead.
v-jingzhangCommunity Support
Hi Rumi
There are several blogs and videos introducing workarounds to this. You may have a try!
Page-Level Security workaround in Power BI - RADACAD
Page level security with RLS - Microsoft Fabric Community
Can you do Page-Level Security in Power BI? - YouTube
Or you may have a look at the Object-level security in Power BI. This can limit users' access to data in specific tables/columns.
Object-level security (OLS) with Power BI - Power BI | Microsoft Learn
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
