Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Experts,
Is there a method to create a page that is not affected by any roles ?
Example: i have an existing page that has a role for each business user. Each of them access to this existing page with their own Sales Data in details. Now, i want to create another new Page that is able to populate the total company's Sales data in summary. This page should not be affected by Roles, which means all Business users are able to see the total Company Sales in summary from this page.
Thanks & Regards,
Desmond KOH
Solved! Go to Solution.
Hey @Anonymous ,
basically, this is not as simple as we might want. The reason for this is simple, the implemented row level security.
Most of the time RLS is implemented on dimension tables, e.g. product. RLS prevents a user is able to see all the sales data, instead, the user is able to see only the products he is responsible for. In situations like this, I create a second "fact table" that does not contain the product dimension, of course, all other rows are grouped. Sometimes these tables are called "aggregation" tables.
Hopefully, this provides some ideas on how to tackle this challenge.
Regards,
Tom
You can use the concept of Page Level security which can be implemented as a workaround.
Refer this- Page-Level Security workaround in Power BI - RADACAD
Hey @Anonymous ,
basically, this is not as simple as we might want. The reason for this is simple, the implemented row level security.
Most of the time RLS is implemented on dimension tables, e.g. product. RLS prevents a user is able to see all the sales data, instead, the user is able to see only the products he is responsible for. In situations like this, I create a second "fact table" that does not contain the product dimension, of course, all other rows are grouped. Sometimes these tables are called "aggregation" tables.
Hopefully, this provides some ideas on how to tackle this challenge.
Regards,
Tom
Thanks, got you!
To duplicate another dimension so that the Roles created under the original Table is not affecting it. 🙂
Hey @Anonymous ,
I do not create a second dimension table, I create a second fact table, but this time without the column that is referenced by the dimension table. Then I'm able to create the Totals, but w/o putting securable details at risk.
Regards,
Tom
For me, i copy new table from the original. And this table works for the summary result under another page.
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
98 | |
89 | |
73 | |
62 | |
61 |