cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
acbg
Resolver III
Resolver III

Deployment Pipeline Calculated columns

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?

 

 

1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

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.

View solution in original post

7 REPLIES 7
mshparber
Helper I
Helper I

Strange, because when I deploy from Dev to Test and Dev has a new calculated column, it is NOT calculated in the Test... The visual shows error

@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?

Hi,

This is not a known issue. Please open a support ticket for us to investigate it.

Thank you,

Lee

acbg
Resolver III
Resolver III

@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.

AlexisOlson
Super User
Super User

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.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors