Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Syndicate_Admin
Administrator
Administrator

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

6 REPLIES 6
Syndicate_Admin
Administrator
Administrator

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

Syndicate_Admin
Administrator
Administrator

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

HarishKM
Impactful Individual
Impactful Individual

@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.

 

HarishKM_0-1692877793575.png

 

 

Thanks

Harish M

 

 

slorin
Super User
Super User

Hi,

 

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

 

Stéphane 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors