Forum Discussion

anelliaf's avatar
anelliaf
Icon for Helper II rankHelper II
6 years ago
Solved

Json Timestamp to Date

Hi,   I parsed a JSON file into a few columns in Power BI.  I have a column called 'CreationTime' that seems to be a timestamp field, i.e.:   2019-09-27T15:53:14   I'd like to break this down i...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi anelliaf 

    Please change it to "datetime" type.

     

    select "column1", then add column-> date only,

    select "date", then add column-> year/month,,,ect

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
anelliaf's avatar
anelliaf
Icon for Helper II rankHelper II
6 years ago

When I go to Model, click on the column 'CreationTime', and in the Properties page I choose Date under DataType I receive the following message:

 

We can't automatically convert the column to Date type.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi anelliaf 

Please change it to "datetime" type.

 

select "column1", then add column-> date only,

select "date", then add column-> year/month,,,ect

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.