Use ElasticSearch data with porwerbi - Issue reading ISO date

[Anonymous]

Hello, 

I am using data from ElasticSearch through an ODBC connector to visualize and build a dashboard in PowerBi. 

I have trouble reading ISO date. My date looks like this on ElasticSearch : 2021-03-16T13:23:56.546345+00:00

But when I requesting data from PowerBI with a simple query : "Select * from source", PowerBI is setting all ISO dates  at midnight : 

2021-03-16T12:00:00

I tried changing settings but it didn't solve my issue. 

Could you please help me ? 
Regards, 

Olivier, Data Engineer 

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

You need to use 'DateTime.FromText'  to convert the date format in power query.

Please refere to this same thread.

Support-for-ISO-8601-Date-Time-format-DateTime-ToString-quot-O 

Best Regards,
Community Support Team _ Eason