Date not showing in direct query

Hi Anonymous ,

The built-in date hierarchy isn't available when using DirectQuery. You could click to upvote this idea or add your own comments.

---

 

• No built-in date hierarchy: When importing data, every date/datetime column will also have a built-in date hierarchy available by default. For example, if importing a table of sales orders including a column OrderDate, then upon using OrderDate in a visual, it will be possible to choose the appropriate level (year, month, day) to use. This built-in date hierarchy isn't available when using DirectQuery. If there's a Date table available in the underlying source, as is common in many data warehouses, then the DAX Time Intelligence functions can be used as normal.

 

---

Reference: Modeling limitations when using DirectQuery in Power BI

It is suggested to manually create a custom date hierarchy in your underlying source or just in Power BI Desktop. 

Best regards

Icey

If this post helps,then consider Accepting it as the solution to help other members find it faster.