Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Date type from Tabular source

Hello, 

 

I have a datetime in my tabular which I want to be used in my Power BI desktop as Date field (and use data hierarchy). 

Unfortunately it appears as normal text field. 

 

Here's the definition of my field in my tabular : 

 

Note : The field comes from a view and is a datetime type. 

 

Here's what I get in my tabular : 

 

Finillay  what I'd like to get (example directly connected to SQL Server view) : 

 

Do you have an idea how I can resolve this issue ? 


Thank you, 


Tus

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous 

    It is of date type only. Whenever source is tabular model it will not display calendarsymbol before column.

     

    If you want to verify it at power bi side just drag the column in slicer. if it is allowing you to use after/before/between slicer then it is of datetype only.

     

    Thanks & regards,
    Pravin Wattamwar
    www.linkedin.com/in/pravin-p-wattamwar

    If I resolve your problem Mark it as a solution and give kudos.