DAX RLS formula

[surv03]

What would be a DAX formula for the case, when people, who have an email, could see the data belonging to their email, whereas,
those people with no email, could see all the available data?

[Joe_Barry]

Hi @surv03 

Create two roles

• Admin (Don't add any Dax)
• Reader ( Table[Email] = USERPRINCIPALNAME() )
• Upload your report

Go to the Dataset

• Click on the 3 dots
• Security
• Add the people who should have Admin Access to the Admin role and then Save
• Repeat for the reader role.

Ideally you should have Dynamic Security groups in Azure, so you don't have to manually add people to roles

For RLS to work, None should have any access to the Workspace where the report is stored.

Joe