cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kalhelo
New Member

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

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

1 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.

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@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

@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.

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!