date from sharepoint list is not appearing as date in powerBI

[ssakhuja]

Hi, I have calculated column in sharepoint list which is selected as follows. 

when I loaded the data in powerBI and open the query editor, it is shown as 

When I tried to change the type to date, it gives error:

Please help. thanks

[Anonymous]

Hi @ssakhuja ,

Is your problem solved? There was no problem with testing on my side. If not, please provide more details, such as what your error message is.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[Anonymous]

Try

DateTimeZone.FromText([YourColumnName])

But I would just split off everything after the last ":" which would make it a datetime that you can just change the type on. 

--Nate