Forum Discussion
Incremental Refresh and Calculated Columns
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.
Hey scrimpton ,
calculated columns will be re-calculated for the entirety of the table.
Regards,
Tom
3 Replies
Hey scrimpton ,
calculated columns will be re-calculated for the entirety of the table.
Regards,
Tom
Appreciate the reply TomMartens . That's what I thought. Do you know a link where we can actually find this?
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
