Forum Discussion
Deployment Pipeline Calculated columns
That's what I would expect. If you don't actually want today, then maybe you can take a MAX over one of the date columns in your dataset instead.
AlexisOlson Thanks for the confirmation. Unfotunately I can't use max date, would you know if I move the calculated column to Power Query side (DateTime.LocalNow ) if the same thing would happen? Would the column get re-calculated in power query if deployed via deployment pipeline?
It would use the time when the query was refreshed. I'd guess that the query would be refreshed during deployment.
Maybe you can create a dataflow that both test and prod connect to so that they can both be in sync?
Thanks for the confirmation again. Going to just put Today() in the source side since data from there does not aut-refresh when deployed using deployment pipeline.