how Admin User can see other data for that application

[msudulag]

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

[v-qiuyu-msft]

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]

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]

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

[v-qiuyu-msft]

Hi @msudulag,

Assume the data likes below:

You can create two roles, one for Admin role without any filter applied, and the other for OtherUser with filter by UserName().

After publish the report to service, go to Dataset-> Security, add email address under Admin role in this scenario is qiuyun@qiuyunus.onmicrosoft.com. Add rls@qiuyunus.onmicrosoft.com under OtherUser role.

Best Regards,
QiuyunYu

[msudulag]

Thanks for your reply.

here i don't who are having Admin role,they are around 100 users,dynamically we need to search ,and where i have to write DAX for this and also need to validate the user having Admin or not

so that my report should show.

Regards

Mallikarjunarao S

[v-qiuyu-msft]

Hi @msudulag,

It seems you are not looking for Row Level Security, instead, you want to use DAX to find who is admin or common use, right?

Would you please share some dummy data? Please clarify the condition to be a admin role?

Best Regards,
Qiuyun Yu

[msudulag]

Hi @v-qiuyu-msft,

I am looking for RLS with Admin and other user

I have user,application,role  and fact_Table

if an user role id is Admin for a particular Applicaion he can see all data for that Application

if not he can see only his data only.

Regards

Mallikarjun

[v-qiuyu-msft]

Hi @msudulag,

How did you define the relationships among those tables: user,application,role  and fact_Table? Can you show some dummy data about those tables?

By the way, here is the a article which you can go through: Dynamic RLS via Hierarchy in Power BI.

Best Regards,
Qiuyun Yu

[msudulag]

Hi @v-qiuyu-msft,

thanks for your reply,

In my fact table i am having user key,role key and application_key columns

here i need to check the particular user for particular application what kind of role he has

if the role is Admin then "all Data " else "only user data "

Regards

Mallikarjun