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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
Jeffrey2
Helper I
Helper I

Date Format changes unexpectantly

I have a power query that pulls dates from a US based file location with US based formatting (I'm in the US as well). In the power query editor, the dates appear correct. I even changed the date columns to English-USA using the "Locale" feature, so the dates appear as MM/DD/YYYY.

 

Unfortuantely, when I go to the regular Excel screen with the data loaded, the date fields appear in DD/MM/YYYY format, and the format doesn't say "Date". It says "Custom". 

 

I usually have an offsite team that refreshes this form every day, and they are based in an area with the DD/MM/YYYY format. However, even if I refresh it, it doesn't return to the regular MM/DD/YYYY format. 

 

I cannot figure out why this is happening. Any help would be greatly appreciated. 

1 REPLY 1
RIBUZ
Frequent Visitor

Can you share some pictures of the issue? it sounds to me that this problem is coming from excel configuration rather than Power Bi.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors