Row Level Security and summarize table

[fabiocesarei]

hi , I have created a role based on the different companies to manage different profiles ,
I tested the operation on the PBI desktop and everything works.
In PBI service I associated the role
to a user who is part of my team but he sees the complete data , where am I wrong ?
should the role also work with the table summarize that have not among those used in the filter fields
( the Tables were created from that filtered ) ?

Thanks

[v-yuezhe-msft · Accepted solution]

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

[fabiocesarei]

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

[v-yuezhe-msft]

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