import from excel date issue

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