Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Incoming Username (embedded Dashboards)

For several reasons we 'misuse' the username string provided from our host to the embedded Power BI dashboard.  (...|username| extra...) With Dax(pathitem) we retreive the info we need.  We cannot provide this info into a database field, for that reason we solved it like this.  The reason why we want all this is complicated, so I stick to the main issue we have now.  
 
When we use the retreived info in a new calculated column we get the following error. 
CUSTOMDATA, USERNAME, USERCULTURE and USERPRINCIPALNAME functions are not supported in calculated tables/columns. These functions may only be used in Measures or in the AllowedRowsExpression.
 
Is there any way to solve this so we can use the info in a new column? 
Need Help

5 Replies

  • JosefPrakljacic's avatar
    JosefPrakljacic
    Icon for Solution Sage rankSolution Sage
    6 years ago

    Hey Anonymous ,

     

    unfortunately - no. (If I have understood you correctly)

     

    What are you actually trying to achieve? - Is this thread somehow helpful?

     

    If this post was helpful may I ask you to mark it as solution and give it some kudos?

    Have a nice day!

    BR,
    Josef

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi JosefPrakljacic 

       

      Thnx for your reply. 

      Ths issue we have is that we need to calculate with time.  1 dashboard can have multiple users in different timezones. They need to see the data in their own timezone.  For that reason, we need to recalculate time.