Performance Implications Of Using Calculated Columns In Composite Models On Power BI Semantic Models
Chris Webb BI
FEBRUARY 4, 2024
I don’t have anything against the use of calculated columns in Power BI semantic models in general but you do need to be careful using them with DirectQuery mode. In particular when you have a DirectQuery connection to another Power BI semantic model – also known as a composite model on a Power BI semantic model – it’s very easy to cause serious performance problems with calculated columns.
Let's personalize your content