Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
70 | |
66 | |
50 | |
31 |
User | Count |
---|---|
116 | |
99 | |
75 | |
65 | |
40 |