Incremental Refresh and Calculated Columns

[scrimpton]

When refreshing an IR dataset, do calculated columns get recalculated for the entirety of table or for just the incremental periods only?

Would like to understand this as I'm hitting the memory throttling.

[TomMartens · Accepted solution]

Hey @scrimpton ,

calculated columns will be re-calculated for the entirety of the table.

Regards,

Tom

[scrimpton]

Appreciate the reply @TomMartens . That's what I thought. Do you know a link where we can actually find this?

[TomMartens]

Hey @scrimpton ,

here you will ind at least an indication: Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn

Other processing operations must still occur, like merging partitions and recalculation, but it usually takes much less time than the initial refresh.

here you will find that a Process Recalculate also recalculates calculated columns: Process Database, Table, or Partition (Analysis Services) | Microsoft Learn

Hopefully, this provides the information you are looking for.

Regards,

Tom