Date Format

[Anonymous]

Hi Folks,

I'm unable to see the date hierarchy for a specific field having the  (( Data type: Date )) and (( Format: dd-mm-yyyy )). 
( Note: Data source is connected to Spark DB, direct query  )

Spark code :

CAST(P.posting_date_of_document AS DATE) AS posting_date_of_document 

Thanks in advance!!

[v-alq-msft]

Hi, @Anonymous 

As is said in the document , there is no built-in date hierarachy in Direct Query mode. When importing data, every date/datetime column will have a built-in date hierarchy available by default. The 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.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[az38 · Accepted solution]

Hi @Anonymous 

according https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about 

 This built-in date hierarchy isn't available when using DirectQuery