A Power BI developer needs to implement dynamic row-level security where each user sees only data matching their email in the Employee table. Which DAX expression correctly filters the model?

Question

Power BI — Hard

A Power BI developer needs to implement dynamic row-level security where each user sees only data matching their email in the Employee table. Which DAX expression correctly filters the model?

Accepted Answer

To implement dynamic row-level security in Power BI, the DAX expression `[Email] = USERPRINCIPALNAME()` is used, as it correctly filters the model based on the user's email. This is because `USERPRINCIPALNAME()` returns the user's email address. Other options are incorrect as they return different user identifiers.