Forum Discussion

fabiocesarei's avatar
fabiocesarei
Advocate I
9 years ago
Solved

Row Level Security and summarize table

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

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      fabiocesarei
      Advocate I
      9 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago


        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