Forum Discussion

BIttaM's avatar
BIttaM
New Member
4 years ago
Solved

DateTime Datatype not pulling through to Power BI from Tabular editor to Power BI

Hi All, 

 

I am setting a datatype to DateTime in Tabular editor, in the Database  it is a DateTime field but when I pull it through to PowerBI it's keeping the Date but losing the time.

 

Any idea how to resolve?

 

Thanks

Need Help
  • BIttaM's avatar
    BIttaM
    4 years ago

    Hi,

     

    I figured it out, I had to provide the Format string in Tabular editor for it to be pulled through correctly , although the datatype was DateTime.

     

    It had to have it as dd/MM/yyyy HH:mm:ss.

     

    Thanks

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    BIttaM , Please check the data type in Power Query. If it is date there, it might lose time.

    Other wise along with datetime, choose a format to display time

    • BIttaM's avatar
      BIttaM
      New Member
      4 years ago

      Hi,

       

      I figured it out, I had to provide the Format string in Tabular editor for it to be pulled through correctly , although the datatype was DateTime.

       

      It had to have it as dd/MM/yyyy HH:mm:ss.

       

      Thanks