- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

How 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 local bi file.
But what happens with calculated column in directqueries? Are calculated columns persisted in the data source and when we refresh the visuals it queries the data source every time?
I have created a custom column through power query vs calculated column for directquery and it seems like the calculated column is slower for the report. Any clarifications would help. Thanks.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@wpf_ That is exactly what I think happens behind the scenes, yes.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hello good morning, the calculated column can be used as the end of a relationship in a composite model?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@wpf_ That is exactly what I think happens behind the scenes, yes.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Makes sense. I guess that’s why the calculated column version I had took longer then the custom column version. Thanks!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-18-2024 09:59 PM | |||
07-03-2024 01:57 AM | |||
06-03-2024 08:27 AM | |||
06-07-2024 12:35 AM | |||
08-05-2024 11:08 PM |
User | Count |
---|---|
141 | |
115 | |
82 | |
63 | |
48 |