Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
Hi,
We have a SQL database (v 12.0.2000.8) and when I connect this to PowerBI desktop; for integer fields I can see the greek "E" but I cannot see the grid icon for DateTime and Date fields.
Help!!!
Thanks!
Solved! Go to Solution.
Hi @SachinC ,
Your doubts are correct. At present, the latest version of Powerbi Desktop does not support the built-in date hierarchy when you use direct query (that is, the calendar icon will not appear).
You can refer to related posts: Solved: Date Hierarchy in Direct Query - Microsoft Power BI Community
Hope to help you.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @SachinC ,
Your doubts are correct. At present, the latest version of Powerbi Desktop does not support the built-in date hierarchy when you use direct query (that is, the calendar icon will not appear).
You can refer to related posts: Solved: Date Hierarchy in Direct Query - Microsoft Power BI Community
Hope to help you.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Strange one, I don't know if it's a clue - but this doesn't work with Direct Query. When I change to Import Mode and unchecked the option Time Intelligence (in Options) load my table then go to Options again and check the Time intelligence option, my icons appeared! Sounds like a bug to me! Pls help.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!