Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Hi @Anonymous ,
Please try the suggestions mentioned in below link:
Regards,
Daniel He
Hi @Anonymous ,
Please try the suggestions mentioned in below link:
Regards,
Daniel He
Thanks! I changed the privacy settings on all the data to Organizatioal and this seems to have worked.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.