Incoming Username (embedded Dashboards)

Anonymous · ‎10-04-2019

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?

JosefPrakljacic · ‎10-05-2019

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 · ‎10-06-2019

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.

v-lili6-msft · ‎10-07-2019

hi, @Anonymous

These function could not be used in calculated column, and I think you could use them to create a measure.

Please share some simple sample data and your expected output, we could have a test on it.

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎10-09-2019

Thnx all for your replies so far. I've added a small test dashboard to clarify my issue.

Steps: login as user test|4

pathitem returns 4 in measure 'item'.

The datetime field needs 4 extra hours provided by the pathitem measure. In this test I expect the current datetime + 4 hours

(field calculated time)

Again: a measure to solve this issue is not an option. I have to do a recalculation for each datetimefield in my data set so i need to add an new calculated column.

PowerBI file