Forum Discussion

connork's avatar
connork
Frequent Visitor
9 years ago
Solved

RLS Access All Dynamic List

New to RLS so bear with me: I have a dashboard that includes RLS restricted by customer, and the reporting is working well; business owners can only see reporting on customers they are assigned.. ...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    Hi connork,

     

    First, please create a calculated column to your table with the DAX below.
    All = 1

    Then create a new role: [All]=1

     

    Then you can add users who can access all data to this role in Power BI Services.

     

    Regards,

    Charlie Liao

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

Hi connork,

 

First, please create a calculated column to your table with the DAX below.
All = 1

Then create a new role: [All]=1

 

Then you can add users who can access all data to this role in Power BI Services.

 

Regards,

Charlie Liao