Sun.Feb 04, 2024

article thumbnail

Performance Implications Of Using Calculated Columns In Composite Models On Power BI Semantic Models

Chris Webb BI

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.

Sales 271