Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now
I have 3 table
Dim_Employee, Dim_Auth, Fact
I want A to be able to see only 11 and 13 groups of data.
How can I do RLS?
I already make dax at fact like delow.
---
[group] IN
SELECTCOLUMNS(
FILTER(
'Dim_Auth',
Related('dim_employee'[Big_group]) = [Big_group]
),
'Dim_Auth'[group]
)
---
but i can see all..
Hey @multt0 ,
I'm wondering if you are aware of this article: Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn
Share the relationships of the tables in your semantic model.
Regards,
Tom
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 11 | |
| 10 | |
| 9 | |
| 8 | |
| 7 |
| User | Count |
|---|---|
| 44 | |
| 34 | |
| 27 | |
| 20 | |
| 19 |