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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Issue with date format changing once published to Power BI service

I've noticed an issue with my PBI report that was created from PBI Desktop.

 

The data I use has not changed. 

 

When refreshing report in Desktop this works perfect. However after the report is published to PBI service the date format changes from dd/mm/yyyy to mm/dd/yyyy resulting in dates being displayed incorrectly. 

 

e.g date for today 02 June 2020 is now showing as 06 Feb 2020.

How do I stop this from happening?

 

Untitled.png

10 REPLIES 10
Kokkanti
Frequent Visitor

@KatharineC  Did you found any solution for this Issue ?

Please let me know even i am facing same issue

Thank you

KatharineC
Frequent Visitor

I have the same issue, just with my date slicer though:

Desktop:

KatharineC_0-1671125178214.png

Published report:

KatharineC_1-1671125319467.png

This is the same field in the slicer and the tooltip.

 

Any suggestions would be great.

Here is the solution I found @Kokkanti :

 

Issue with date format changing once published to ... - Microsoft Power BI Community

 

KatharineC_1-1693815429920.png

 

Fix:

 

EVERYTHING was set to English (Ireland) or else default Windows language, or so I thought...

Browser languages, language option in Power BI desktop, Windows default language

 

Go into settings on Power BI server:

And set the language to default browser language (NOT English)

 

😊

See also Manage Date Formats in the Power BI Service (mssqltips.com)

 

Thank You. @KatharineC 

v-xicai
Community Support
Community Support

Hi @Anonymous ,

 

Based on my test in the latest version 2.81.5831.821 of Power BI Desktop, the Date Format is the same in Power BI Desktop and Power BI Service. You may upgrade the Power BI Desktop, and try it again.

109.png108 data format.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Good Morning Amy/Gilbert,

 

Thanks for trying to resolve this.

I'm currently running the latest version of PBI Desktop 2.81.5831.821 x64 bit (May 2020).

 

Changing the date format to custom dd mmmm yyyy produces the same issue.

 

This only appears to happen once the Power BI service refreshes using my Personal Gateway. If I manually publish the report this works fine until the next refresh.

 

That is interesting as I have not had that experience

What version of the Personal Gateway are you using? I think it might be an older version.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

Currently running Gateway 3000.40.15 (May 2020). I've tried redownlading both Desktop & Gateway.

Hi  @Anonymous  ,

 

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

 

Best regards

Amy

GilbertQ
Super User
Super User

Hi there

If you go into the relationship view, what if you change your Date column to use a Custom Format string?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors