import from excel date issue

[Syndicate_Admin]

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

[Syndicate_Admin]

but why this happens ? 

[v-cgao-msft]

Hi @Syndicate_Admin ,

Check your browser language settings, try changing your browser language to match the Excel file.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[ronrsnfld]

Does this help? https://community.fabric.microsoft.com/t5/Service/Language-Settings-Power-BI-Cannot-set-to-British-E... 

[Syndicate_Admin]

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

[HarishKM]

@Syndicate_Admin Hello,
You can select the date column the select column tool then you can use your paste format tring dd/mm/yyyy in format option. now you sucessfully updated your date format. you can refer below.

Thanks

Harish M

[slorin]

Hi,

Date.FromText([date], [Format="dd/MM/yyyy"])

Stéphane