This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is now in read-only for platform upgrade. Learn more
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
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 15 | |
| 11 | |
| 9 | |
| 8 | |
| 6 |
| User | Count |
|---|---|
| 27 | |
| 23 | |
| 17 | |
| 13 | |
| 13 |