import from excel date issue

(0) Share

Report

Posted on by chahineatallah1

249

Hello

I have an excel file with date formats as per my uae region "dd/mm/yyyy"

Now when i import the file into dataverse, power query online /dataflow opens and the dates are imported into "mm/dd/yyyy" format, although in my tenant format for dates is also as per uae region "dd/mm/yyyy"

In addition to that when i try in the power query online to change the date type using locale, it doesn't work, usually in power query desktop i used to use locale and change it to usa region then it will give correct values "dd/mm/yyyy", but here in dataverse import this method is not working

Why is that? is it a bug or am missing something?power query/dataverse formatexcel dates format

Categories:

Tables

Microsoft Dataverse

Dataflows

All responses (2)

Answers (0)

chahineatallah1 249 on at

Like (0)

Report

Re: import from excel date issue

but why this happens ?
chahineatallah1 249 on at

Like (0)

Report

Re: import from excel date issue

No this is in power query desktop, am using power query online/dataflow for importing data into dataverse