Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi Experts,
I am trying to implement RLS on mixed mode (Direct & Import)
This is how my model looks like:
1. I created one Parent Power BI file where I have a Geo dimension table.
2. I created 2 child pbix where I am using direct query of Parent file.
3. Then I imported RLS table into child file using import mode. So this makes the Child report as mixed model.
4. Finally I created MRLs using anage roles in each child file where I am using this formula : "[Email]=userprinciplename()".
when i tested this scenario on Power BI desktop, RLS seems to work but if i test it on Power BI service RLS is not working
I am attaching those files for your reference please suggest me how to resolve this issue.https://drive.google.com/drive/folders/1dQpM-P3u8O0fQvqEC7U4Vz-JEhml9h6z?usp=drive_link
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 74 | |
| 61 | |
| 27 | |
| 23 | |
| 21 |