Forum Discussion

Marke525's avatar
Marke525
Frequent Visitor
5 years ago
Solved

Date Format Problem

I am transfering a date from a calculated field in sharepoint.  In sharepoint I have set the output as "Date and Time" with a "Date Only" format.  When I transfer this to Powerbi, it appears as: 2021...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, Marke525 

    In value '2021-01-25T23:33:42Z' ,the T  is just the separator that the ISO 8601 combined date-time format requires. You can read it as an abbreviation for Time.The Z stands for the Zero timezone, as it is offset by 0 from the Coordinated Universal Time (UTC).

     

    This type of data (text) can not be directly converted into a date format. As a workaround you can  create  a new column to extract the date.

    Please check my sample file more details.

     

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

     

Marke525's avatar
Marke525
Frequent Visitor
5 years ago

Thank you for the suggestion.  Unfortunately, this does not work, it returns the error:  " We can't automatically convert the comun to Date/Time type."