Data Refresh Error - We cannot convert the value "[Function]" to type Function

[Anonymous]

I have a column in my dataset for timestamp which comes in as an epoch datetime. I have another column that is the duration (in milliseconds).

I've also created a new column that adds the duration to the timestamp (to get the end date). The formula is:

[timestamp] + #duration(0,0,0,([duration]/1000))

This works perfectly in PowerBi Desktop but when I publish to the service, I get the following error when refreshing the dataset:

We cannot convert the value "[Function]" to type Function. Table: Calls.

Any ideas on why this is? My other Custom Columns and functions all work fine - it's just this one.

[v-danhe-msft · Accepted solution]

Hi @Anonymous ,

Please try the suggestions mentioned in below link:

https://social.technet.microsoft.com/Forums/en-US/bee8a8e3-c8bd-48c6-a2c3-5d00bc5031b1/expressionerror-cannot-convert-the-value-quotfunctionquot-to-type-function?forum=powerquery

Regards,

Daniel He

[Anonymous]

Thanks! I changed the privacy settings on all the data to Organizatioal and this seems to have worked.