POWER BI [PI-300]: You have a Power BI Desktop dataset that includes a table named Salesperson. The table includes a column named UPN. UPN contains the user principal name of the salesperson’s Microsoft Entra ID account.

You need to ensure that each salesperson will only be able to see the rows in the Salesperson table where the UPN column value matches their User Principal Name.

Which two actions should you perform? Each correct answer presents part of the solution.

Question

You have a Power BI Desktop dataset that includes a table named Salesperson. The table includes a column named UPN. UPN contains the user principal name of the salesperson’s Microsoft Entra ID account.

You need to ensure that each salesperson will only be able to see the rows in the Salesperson table where the UPN column value matches their User Principal Name.

Which two actions should you perform? Each correct answer presents part of the solution.

da-bi · Accepted Answer

Add a DAX expression filter to the Salesperson table.
This answer is correct.
Create a role.
This answer is correct.

POWER BI [PI-300]

Add a DAX expression filter to the Salesperson table. This answer is correct. Create a role. This answer is correct.

Author