Include Date/Time intelligence for direct query

Would love to see some enhancements on direct query feature in powerbi. I struggled a lot to find auto date hierarchy in direct query ,later I found there is no possibility of date/time intelligence for direct query.

Team should enhance this feature a bit