Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
but why this happens ?
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
No this is in power query desktop, am using power query online/dataflow for importing data into dataverse
@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
Hi,
Date.FromText([date], [Format="dd/MM/yyyy"])
Stéphane