Forum Discussion

iowakrz's avatar
iowakrz
Frequent Visitor
7 years ago
Solved

Date Hierarchy in Direct Query

Is there a solution to getting the date hierarchy in Direct Query?  I noted some postings saying it was not available but they are from 2016.  I'm hoping there has been a solution devised since then....
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi iowakrz ,

     

    Currently, the built-in date hierarchy is not yet available when using DirectQuery mode. You could click to upvote this idea or add your own comments.

     

    As a workaround, you could create a custom date hierarchy manually. Please create [Year], [Quarter], [Month], [Day] columns first, right-click the original Date column and choose 'New Hierarchy', then, drag [Year], [Quarter], [Month], [Day] columns to place them under [Date] column.

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi iowakrz ,

 

Currently, the built-in date hierarchy is not yet available when using DirectQuery mode. You could click to upvote this idea or add your own comments.

 

As a workaround, you could create a custom date hierarchy manually. Please create [Year], [Quarter], [Month], [Day] columns first, right-click the original Date column and choose 'New Hierarchy', then, drag [Year], [Quarter], [Month], [Day] columns to place them under [Date] column.

 

Best regards,

Yuliana Gu

emmanuelm's avatar
emmanuelm
Regular Visitor
3 years ago

Thanks for your solution, it is a good workaround waiting the hierarchical date into Direct Qurey . I voted for that !!!!