DAX RLS formula

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

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.

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.

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.