Sorry if this has been covered elsewhere...I couldn't find it.
In Power BI Desktop, one of the SQL Server dimensions has an extra attribute [.Value]:
compared to Excel:
I can also see these date attributes also have a different icon to other fields. Can anyone help explain?
Thanks,
Ian.
Hello Ian,
I believe that is from the Auto date/time that PowerBI does when the setting is left on and you have no date table marked in the model although it should be Snapshot Date.Date
Hello Ian,
I believe that is from the Auto date/time that PowerBI does when the setting is left on and you have no date table marked in the model although it should be Snapshot Date.Date
Thanks @jdbuchanan71 : much appreciated.
I'll talk to our developers; I get this when I try to turn it off:
Not a big deal; I can ignore it. A colleague just asked me about it and I thought I'd ask here. Thanks again.
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
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.
