Forum Discussion
wpf_
Post Prodigy
Post ProdigyHow does calculated columns work in directquery?
So if i understand correctly, for import mode, calculated columns are loaded into the model during a data refresh. And once it's loaded any queries are to the calculated column stored within the loc...
wpf_ That is exactly what I think happens behind the scenes, yes.
wpf_Post Prodigy
Post Prodigy
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?
Greg_Deckler
Community Champion
Community Championwpf_ That is exactly what I think happens behind the scenes, yes.
- wpf_
Makes sense. I guess that’s why the calculated column version I had took longer then the custom column version. Thanks!