Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Employee
Employee

@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

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

 

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors