Change Date Time Zone from text to Date/time/Zone

[Anonymous]

Hi All,

We created a custom dimension to extract the timestamp information from Google Analytics, values we received are in the format of  2018-02-03T14:30:41.764+01:00 

Now when I tried to change the format of this value in power BI to Date/Time/Timezone it is giving me error.

Any suggestion how to change this field from 'text' to Date/Time/Timezone.

[Greg_Deckler · Accepted solution]

Are you in Query Editor or no? When I put these into an Enter Data query, in Query Editor they come in as Date/Time/Timezone. But, once it comes into the model there is no equivalent format that I can find.

[Anonymous]

@Greg_Deckler I load the data directly from the database and there it was defined as VARCHAR (String). When I am trying to change the format from the query editor while loading it gives me error.