DAX Command/Role not showing up when I publish to PowerBI Service

[jimlevin]

Hi,

I've built a report and added a new role with DAX command to use userprincipalname() when users are looking at the report. When I test the role/expression in PowerBI desktop I get the desired behavior, however when I publish the same report to PowerBI Service I don't see the new role or expression being used, as my report data isn't being filtered by userprincipalname(). 

Wondering if I'm not publishing correctly or missing some other setting, has anyone else dealt with this issue before?

Please advise, thanks.

Jim 

[az38]

Hi @jimlevin 

the issue could be is in different usernames at desktop and server

try to debug by creating some visual like card and column=userprincipalname() and compare in desktop and server version. I think it will be different

do not hesitate to give a kudo to useful posts and mark solutions as solution

[jimlevin]

@az38 Thx for the response and suggestion -- i've verified that my username is the same in both desktop and service.