cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
msudulag
Helper II
Helper II

role level security dynamically for admin and other

RLS.GIF

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Hi All,

 

The above image is my data model,from this i want develope row level security,scanario is 

If a user is Admin then he can see all records,if he is not Admin he can see only his records, how we can implement dynamically.

we can do one way as per my knowledge that is we need to create 2 roles one for Admin and another for non Admin

after that Assigned users those roles then we can do.

Here my case is need to implement dynamically,we need to validate users admin or not based on that need to give .

Please help with suggestion.

 

Regards

Mallikarjun

 

 

 

 

 

3 ACCEPTED SOLUTIONS

@msudulag

 

If a user has multiple roles include Admin, as I understand, he/she should can see all records when he/she sign in to Power BI Service with his/her email, right?

 

Please try with following Table filter DAX expression

 

role level security dynamically for admin and other_2.jpg

 

Best Regards,
Herbert

View solution in original post

Hi Herbert,

 

Yes,same way i need to implement,

 

I have implemented same way which you given DAX,but for me i am getting Error,

In Filter first argument is table name,i given that one only.(GMP USER_APPLICATION_ROLE).

 

Can you please verify the same.Capture4.JPG

View solution in original post

Hi Herbert,

 

Thanks for Your Wonderfull efforts !!

 

Finally i got the solution,You made me my day happy.

 

Feeling very Exicted ,Thanks you Very Much.

 

Regards

Mallikarjunarao

 

 

View solution in original post

5 REPLIES 5
v-haibl-msft
Microsoft
Microsoft

@msudulag

 

You can create a role with expression like below, and then publish to Service. Please refer to my recorded video to see the result.

role level security dynamically for admin and other_1.jpg

 

 

Best Regards,
Herbert

Hi Herbert,

 

Thanks for Your Help on this,

 

Same way i have implemnted in my scanario,i shared to one of my collegue he is not seeing anything,

he has two roles,one is Admin and Another one is Operator.

can you please help me on this.

 

a user have multiple roles like Admin,Operator,supervisor if role name is Admin he can see,other then Admin he needs to see only his records

 

Regards

Mallikarjun

Capture3.JPG

 Here is my id i am not having Admin Role ,but i can see all the records.Can you please help me on this.

@msudulag

 

If a user has multiple roles include Admin, as I understand, he/she should can see all records when he/she sign in to Power BI Service with his/her email, right?

 

Please try with following Table filter DAX expression

 

role level security dynamically for admin and other_2.jpg

 

Best Regards,
Herbert

View solution in original post

Hi Herbert,

 

Thanks for Your Wonderfull efforts !!

 

Finally i got the solution,You made me my day happy.

 

Feeling very Exicted ,Thanks you Very Much.

 

Regards

Mallikarjunarao

 

 

View solution in original post

Hi Herbert,

 

Yes,same way i need to implement,

 

I have implemented same way which you given DAX,but for me i am getting Error,

In Filter first argument is table name,i given that one only.(GMP USER_APPLICATION_ROLE).

 

Can you please verify the same.Capture4.JPG

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.