Forum Discussion

jannahds's avatar
jannahds
Icon for Helper I rankHelper I
6 years ago
Solved

Parse DateTime

Hi there, I'm loading datetime data to Power BI Desktop using the Power Query. I'm pulling the data in from Excel. The date value in the Excel looks like this: 2020-03-29T12:27:49.525+03:00   B...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi jannahds 

    set datetype as datetimezone

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi jannahds 

set datetype as datetimezone

jannahds's avatar
jannahds
Icon for Helper I rankHelper I
6 years ago

Literally worked like magic.  Thank you so much!