Forum Discussion

msudulag's avatar
msudulag
Icon for Helper II rankHelper II
9 years ago

how Admin User can see other data for that application

Hi All,

 

I have User,Role,Application table,here when the user has Admin role for particular application,he needs to see the others data also for that Application only.

 

here we have the relation for table,how to restict to the Admin and other role users


Can any one suggest how to implement.

 

REGARDS

Mallikarjun

Data Modeling

9 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    Hi msudulag,

     

    Not sure I get your point totally. In Power BI service, we can use Row-level security (RLS) with Power BI to restrict data access for given users on row level. Roles will be applied to read-only members in app workspace. Please check if this feature meet your requirements.

     

    If not, please clarify the requirement. What's the Application and Admin role do you mean?

     

    Best Regards,
    Qiuyun Yu

    • msudulag's avatar
      msudulag
      Icon for Helper II rankHelper II
      9 years ago

      Hi @ v-qiuyu-MSFT 

       

      Thanks for your reply,

       

      I mean i have 5 applications ,40 users, 5 roles

       

      so each user have different roles and applicatiooons

       

      if particular application have many users in that who are having admin roles for that person can see the data for all

      if a person having other then Admin role he can view his data only.

       

      Regards

      Mallikarjunarao.

       

      • msudulag's avatar
        msudulag
        Icon for Helper II rankHelper II
        9 years ago

        Hi All,

         

        I have a user _role table, in this we have user and role information,now i need to provide a security for user level,

        i can able to provide user wise but i need to provide security if the user is Admin role he needs to see all data else 

        he can see his data only.

         

        can you please help on this how we can implement in power bi

         

        Regards

        Msudulag