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?

[v-kathullac]

Hi @surv03 ,

we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If  response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

[v-kathullac]

Hi @surv03 ,

we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If  response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

[v-kathullac]

Hi @surv03 ,

we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If  response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

[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