probleme with date/time field : I don't find hierarchie date

[ouafaa]

Hello

I created 2 reports on power bi desktop :

• The 1st report contains a data source that is an Excel file with a date field dd/MM / yyyy
  on this report, I had the opportunity to see the hierarchy of the date and to filter per day, per month, per quarter, per year.
• on the 2nd report, the data source is a SQL server database with directQuery access and with a datetime field. on power bi desktop I have configured this field with the type date/time (dd/MM/yyyy HH:mm:ss) but I can not see date hierarchy like in the 1st report. do you have any idea about the source of this problem?

Thank you for your assistance.

[v-chuncz-msft · Accepted solution]

@ouafaa,

Check No Built in-date hierarchy in Implications of using DirectQuery.

[ouafaa]

Hello,

thank you for your reply

Bests regards

[v-chuncz-msft]

@ouafaa,

Welcome. You may help accept solution. Your contribution is highly appreciated.