cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ianhill123 Frequent Visitor
Frequent Visitor

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

Hi @ianhill123 ,

Please try the suggestions mentioned in below link:

https://social.technet.microsoft.com/Forums/en-US/bee8a8e3-c8bd-48c6-a2c3-5d00bc5031b1/expressionerr...

 

Regards,

Daniel He

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

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

Hi @ianhill123 ,

Please try the suggestions mentioned in below link:

https://social.technet.microsoft.com/Forums/en-US/bee8a8e3-c8bd-48c6-a2c3-5d00bc5031b1/expressionerr...

 

Regards,

Daniel He

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

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

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