I am working on Role Level security using the Dynamic function "Userprincipalname()" based on a column with manager's emails in all associated roows of data. It wirks great in Power Bi Desktop, but when published in the Cloud Service it does not operate as it should. When I test as Role and enter a user's information when assigned as a manager in the in the role options it does not filter the data down, or it give me no data.
If there are any ideas please assist.
Role Test no DataRole TEst with All dataSecurity SetupDesktop Dynamic ExpressionDesktop Data filtered by roleDesktop Data filtered by roleDesktop columns for expression