Page Level Security with multiple fact tables

[Rumi]

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

[v-jingzhang]

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.

[lbendlin]

Abandon this attempt and use separate reports instead.