Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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:
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.
Not very clear, Are you lloking for row-level security
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
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:
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.