Forum Discussion
OS user
Hi all,
i want to display OS user name like Auth\MyNTname
it should be dynamic. who ever open dashboard their NT name should disply. is there any function ?
in QLikview i use =OSUser() to display this. in PBI?
HI Anonymous ,
Try using USERNAME dax function in Power BI.
you can refer following link for details:
https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Anonymous
CONCATENATE only works for 2 objects. You need multiple CONCATENATE and Format().
Access = CONCATENATE("Confidential: Data accessed ", CONCATENATE(USERNAME(), CONCATENATE(FORMAT(NOW(),"YYYY/MM/DD HH:MM:SS"),"is responsible for keeping this data secure.")Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
HI Anonymous ,
Try using USERNAME dax function in Power BI.
you can refer following link for details:
https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Anonymous
CONCATENATE only works for 2 objects. You need multiple CONCATENATE and Format().
Access = CONCATENATE("Confidential: Data accessed ", CONCATENATE(USERNAME(), CONCATENATE(FORMAT(NOW(),"YYYY/MM/DD HH:MM:SS"),"is responsible for keeping this data secure.")Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.