I have two datasets -
1 - Employee cell phone usage data
2 - Employee position look up or hierarchy data. This represents a nested set with parent child nodes with a left and right anchor for each node such that by traversing either anchors you can tell who reports to whom and who is the boss of whom.
Trying to implement row level security in a paginated report with with a nested heirarchy/set model. On PowerBI side, we can implement roles using the USERPRINCIPALNAME() and some custom DAX code.
What is the equivalent of USERPRINCIPALNAME() in report builder? For code I know I have to use VB instead of DAX.
In previous paginated reports that I've published where it was essential to capture the ID of the user running the report, I've used the built-in function "UserID" in report builder. This, when run locally (desktop) returns the user id logged in to the PC which in my case happens to be my 5 digit employee ID , e.g. 12345, but on Power BI service, it somehow translates it into the UPN itself which looks like - "EmployeeName@organization.com".
So bottomline, do I even need to worry about a report builder equivalent of UPN and let the API handle it instead? How would that translate to my code?
The desired end result is that every employee should be able to view their own company cell phone usage $$ amounts (base rate, data charges, roaming, etc.) and the bosses should be able to see the usage of all employees under them.
