The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have a Main PowerBI semantic model with the main app included. (Managers)
I am wanting to create a seperate report that uses the model of the main app but use RLS so Agents can self serve (Agents)
This make it easier than updating two models which is what happens at the moment.
However when I got to view roles etc to add RLS on the Agent report, it is greyed out.
Any help appreciated to achieve this.
You can only put RLS on your own tables, not on the tables from the Main semantic model.
User | Count |
---|---|
44 | |
16 | |
12 | |
11 | |
9 |
User | Count |
---|---|
50 | |
31 | |
22 | |
17 | |
15 |