topic Re: DAX RLS formula in DAX Commands and Tips

DAX RLS formula

surv03 — Mon, 03 Mar 2025 13:31:12 GMT

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?

Re: DAX RLS formula

Joe_Barry — Mon, 03 Mar 2025 13:57:07 GMT

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

Re: DAX RLS formula

v-kathullac — Fri, 11 Apr 2025 11:32:33 GMT

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.

Re: DAX RLS formula

v-kathullac — Thu, 17 Apr 2025 15:50:55 GMT

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.

Re: DAX RLS formula

v-kathullac — Mon, 21 Apr 2025 15:41:14 GMT

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.