Showing results for 
Search instead for 
Did you mean: 
Advocate II
Advocate II

Dynamic Row Level Security (RLS) in SSAS Tabular cube for Power BI Report

We have defined 3 roles in SSAS Tabular Cube 1-role) Admin 2-role) StandardUser 3-role) SuperUser. I am included in all the 3 roles. In the power bi report server StanderdUser is working fine by giving limited access to the data. Could you please let me know if I login as Admin it should by-pass StandardUser & SuperUser and show me logged in as Admin using DAX Query or any other suggestions if possible. Also we want to show a message to the users when the user logins in it should show the message that you are a Admin or standarduser or superuser.

Advocate II
Advocate II

Team, Request your help in providing Dax query for RLS roles

Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.