Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
tobny76
Helper II
Helper II

Temperature and last accessed column in DAX Studio

Hi!
Sorry for posting this question in maybe wrong forum.
I have been looking at this amazing guide from Chris Webb - The complete guide to Power BI memory usage and memory errors

If I am looking at the temperature column in Vertipaq analyzer from Tabular Editor the "Temperature" column and "last accessed" column is working (see picture below).
But when using vertipaq analyzer from Dax studio I don't have any values in the columns.
I am using the latest version of DAX Studio 3.4.0.
How can I get it to work even from Dax Studio?

tobny76_0-1768941378599.png

 

1 ACCEPTED SOLUTION
MattiaFratello
Super User
Super User

Hi @tobny76

 

Please be informed that DAX Studio's Vertipaq Analyzer shows temperature and last accessed values only for Power BI Service/Premium models (via XMLA endpoint), where these metrics track recent column usage to prioritize memory retention—"hot" columns stay resident longer. These fields appear as zero or empty in Power BI Desktop because the engine does not maintain temperature data locally.

 


If this helped, please mark as Answer and give kudos 👍

View solution in original post

3 REPLIES 3
cengizhanarslan
Super User
Super User

DAX Studio can only show Temperature and Last accessed when you connect to a Power BI Service / Premium semantic model via the XMLA endpoin, that’s where the Service keeps and exposes those metrics. In a Power BI Desktop local model, these values will show up as blank/0 because that local engine doesn’t maintain/expose the same temperature tracking.

_________________________________________________________
If this helped, ✓ Mark as Solution | Kudos appreciated
Connect on LinkedIn
AI-assisted tools are used solely for wording support. All conclusions are independently reviewed.
MattiaFratello
Super User
Super User

Hi @tobny76

 

Please be informed that DAX Studio's Vertipaq Analyzer shows temperature and last accessed values only for Power BI Service/Premium models (via XMLA endpoint), where these metrics track recent column usage to prioritize memory retention—"hot" columns stay resident longer. These fields appear as zero or empty in Power BI Desktop because the engine does not maintain temperature data locally.

 


If this helped, please mark as Answer and give kudos 👍

I thought I connected to the power bi service both via TE and DAx Studio via XMLA-endpoint.
But I can see it is working now if I do it again from Dax Studio, so it was a misstake to open Dax Studio from External tools in the desktop!
Thanks for your help! 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.