Forum Discussion

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

RLS - for default Value Show all

Hi,   I have Role based Secuirty using Lookup,When 'America' is the access then america data should be shown ,Same for Asia also , But If i want to show both data ,I want to mention 'All' instead ...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi urpalani,

 

As you already created RLS role for the dataset, to let a user to view all data, please create a role (named "all")  without any filter applied, then add the user as a member of this role.

 

 

Please note if you add the user as member of role you created before, and also add this same user under the role (all), this user will see all data when he view the report.

 

Best Regards,
QiuyunYu

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

    Hi v-qiuyu-MSFT,

     

    Ok if i have one level security,

     

    But in my case i have two level of security,In second level instead of mentioning the values,I will mention as 'ALL' ,then lookup should show all the values for second level security,

     

    Example,

    Country - First Level

    City - Second Level

     

    If I mention Certain city then certain city of the country should show,but if i want to show all city of the country i will mention as 'ALL',So how to handle this in DAX Lookup

  • Mond's avatar
    Mond
    Icon for Helper III rankHelper III
    7 years ago

    What is the syntax for role "All" with out adding user name(s) and in the data set on power bi service.