Forum Discussion
How does calculated columns work in directquery?
wpf_ That is exactly what I think happens behind the scenes, yes.
wpf_ I don't believe that the values are persisted in the data model or the data source. For example, I added a calculated column to a DirectQuery model and it added a total of about 600 bytes to the data model and added nothing to the data source. So, likely it just stores the formula for the calculated column in the PBIX file in the Data Model.
Thank you.
So does that mean that every time I refresh a visual that contains a measure that references a calculated column, it queries the data source and calculates the calculated column then the measure on demand?
wpf_ That is exactly what I think happens behind the scenes, yes.
Makes sense. I guess that’s why the calculated column version I had took longer then the custom column version. Thanks!
