Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
Hello to the hole comunity,
I hava made a report and programed some RLS filtering so each user can see only what should see.
The problem is that I would like to have one page that that this RLS doesent apply so the team are able to se some data of the hole team without filtering.
Is that posible?
Thanks in advanced to the contributors
Greg's solution is doable. You can have a summarized table which is used to provide the summary data of whole team on that page. Keep this summarized table disconnected with other tables, so it will not be filtered by existing relationships between other tables.
Or you can have a look at the following blog. The workaround may be helpful.
Page-Level Security workaround in Power BI - RADACAD
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
@Borjaveigasvh Many times the way this is done is to have a calculated table that has summarized statistics. Then you don't apply RLS to this table.
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 22 | |
| 21 | |
| 20 | |
| 17 | |
| 13 |
| User | Count |
|---|---|
| 58 | |
| 50 | |
| 37 | |
| 29 | |
| 24 |