Forum Discussion

chvale's avatar
chvale
New Member
8 years ago

smalldatetime representation

Hello,

I have a table with a variable being as smalldatetime - eg 1955-12-13 12:43:10.

I can see the data correctly in Azure SQL - with full date & time.

 

However, in PowerBI any filtering I'm doing by the smalldatetime  column, it will show up only the time interpretation - [day], December 12, 1955.

Is it possible to make this show up with the full date & time value?

 

Thank you!

2 Replies

  • chvale's avatar
    chvale
    New Member
    8 years ago

    Hello,

    I have a table with a variable being as smalldatetime - eg 1955-12-13 12:43:10.

    I can see the data correctly in Azure SQL - with full date & time.

     

    However, in PowerBI any filtering I'm doing by the smalldatetime  column, it will show up only the time interpretation - [day], December 12, 1955.

    Is it possible to make this show up with the full date & time value?

     

    Thank you!

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    Check your Power Query and make sure the column is set to a date/time categorization and not date. Then, in Power BI modeling, make sure the format is set to date/time.