Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Calculated column works fine in desktop however if the data set is scheduled refresh then the error below is displayed:
WOrks fine when published from desktop. Problem is only after scheduled or manual refresh.
Calculated column:
Solved! Go to Solution.
Hello GilbertQ,
Thank you very much for the suggestion. I removed all references to NOW() in the query and have the same result. Have another solution for this problem however it should be lilely flagged as an instance where a calucation runs on the Vertipack engine but not in Analysis services. Thank you again for the feedback.
Best Regards
Jeff
I think this has to do with the function "NOW()" because all the PBI Service servers are in UTC. So it would appear that using NOW() is probably returning the wrong value which is causing it to fail.
It will work on PBI Desktop because this is in your current timezone, so now is accurate.
What you would have to do, is to take NOW() and add the hours for your timezone. If for example you are in GMT + 8 you would need to create a variable as shown below.
VAR CurrentDateTime = NOW() + TIME(8,0,0)
Hello GilbertQ,
Thank you very much for the suggestion. I removed all references to NOW() in the query and have the same result. Have another solution for this problem however it should be lilely flagged as an instance where a calucation runs on the Vertipack engine but not in Analysis services. Thank you again for the feedback.
Best Regards
Jeff