Trying to understand Deployment Pipeline.
Pushed changes from test to Prod via deployment pipeline, I noticed Calculated columns got recalcualted.
Was able to notice it as the column is based on Today() dax and it got changed to the day I pushed the changes, not the day data was refreshed (which was a week ago).
Is this normal function or a bug?
Solved! Go to Solution.
@mshparber I see the same as you now. I want to say this is a bug based on what I found a year ago but who knows maybe it was bug back then and MS finally fixed it. Can someone from MS (who is reading this) to advise if this is a bug or not?
@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.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!