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 format
excel dates format
