Do I need to build new measure/add related table systemusers to get current user?

[kalhelo]

Hi Community,

May you guide me how to get the value of the current user while developing Power BI desktop report. For examole to get the current user for open opportunities, won quotes, ..etc 

Do I need to build new measure/add related table systemusers to get current user?

Thank you

[amitchandak]

@kalhelo 

Not very clear, Are you lloking for row-level security

https://docs.microsoft.com/en-us/power-bi/service-admin-rls

https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns...

[kalhelo]

@amitchandak 

So, for Entities likes Quotes, opportunities, orders ..etc; the ownerid is the current user. I want to let the user see the data he owns. For example I might have Matt, Bob, David as salesperson. I want to let everyone of them see his data only once everyone is opening his report.

Thank you

[v-yuta-msft · Accepted solution]

@kalhelo ,

In your senario, you can build a UPN table and configure dynamic row-level security in your report. For more details, I would suggest you refer to the third-party blog below:

https://www.fourmoo.com/2018/02/20/dynamic-row-level-security-is-easy-with-active-directory-security...

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.