Forum Discussion
Row Level Security and summarize table
Hi fabiocesarei,
Could you please share sample data of your table and describe the detailed steps that how you create the role? After creating the role in Power BI Desktop, please validate the role by selecting “Test as role” to check if it works as expected. For more details, please review this article.
Besides, please note that when you publish Power BI Desktop report to a group within the Power BI service, group members that have edit permission can see the complete data even if you add them as members to the defined RLS roles. In other words, make sure that the group members can only view Power BI content within the group settings because roles will be applied to read-only members.
Thanks,
Lydia Zhang
Hi fabiocesarei,
Could you please share sample data of your table and describe the detailed steps that how you create the role? After creating the role in Power BI Desktop, please validate the role by selecting “Test as role” to check if it works as expected. For more details, please review this article.
Besides, please note that when you publish Power BI Desktop report to a group within the Power BI service, group members that have edit permission can see the complete data even if you add them as members to the defined RLS roles. In other words, make sure that the group members can only view Power BI content within the group settings because roles will be applied to read-only members.
Thanks,
Lydia Zhang
Hi Lydia ,I understood this doing various tests
but I thought "edit permission" was only graph.
In this situation if I want to publish reports with edit permissions but filtered by role, I have to initially filter the data set , haven't I?Thanks
Fabio
Hi fabiocesarei,
You would need to filter the data set rather than using role when group members have edit permissions on the group content.
Thanks,
Lydia Zhang
