Date Calendar icon not showing against SQL Server field of type Date and DateTime

[SachinC]

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!

[v-henryk-mstf · Accepted 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.

[SachinC]

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.