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.
Greetings everyone!
I have a report where one of the pages contains a table with 30 columns. However, not everyone can have access to these 30 columns.
Because of this, one solution I thought of was to create several separate reports, assigning RLS to limit people's access.
1 report with 10 table columns, 1 report with 15 columns, 1 report with 20 columns...1 report with 30 columns
However, providing maintenance, when necessary, on all these reports is too time-consuming.
Is there any way to create just 1 report that, based on the person's email, only shows the columns they should see?
Best Regards,
Solved! Go to Solution.
Hi @gdps_vc ,
For this you need to use OLS (Object Level Security) and not RLS please see the links below:
https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-ols?tabs=table
https://www.sqlbi.com/tv/exploring-object-level-security-in-power-bi-unplugged-13/
There are more links available but you can start with these ones.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @gdps_vc ,
For this you need to use OLS (Object Level Security) and not RLS please see the links below:
https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-ols?tabs=table
https://www.sqlbi.com/tv/exploring-object-level-security-in-power-bi-unplugged-13/
There are more links available but you can start with these ones.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
69 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |