Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |