OS user

[Anonymous]

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?

[Pragati11 · Accepted solution]

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]

@Anonymous 

Create this measure: 

Measure = CONCATENATE(USERNAME(),NOW())

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.
  

[Anonymous]

Hi im getting error  while using this.  could you please help how to avoid this? 

whats wrong in this measure

Access= CONCATENATE("  Confidential: Data accessed",USERNAME(),NOW(),"is responsible for keeping this data secure.")

i want to show this  date  foramt   Date(Now(),'YYYY-MM-DD HH:MM:SS'

[Anonymous · Accepted solution]

@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.

[Pragati11 · Accepted solution]

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]

Yeah its working fine  but.  i want to show  current time running  in the dashboard along with Nt name,  like below.