cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
saunders Regular Visitor
Regular Visitor

Date format - Desktop vs. Service

Hi all,

 

I have dates formatted as dd/mm/yyyy in Desktop but when I publish to the service the format get changed to mm/dd/yyyy.  How can I force the service to respect my Australian date format and not adopt the US format? 

 

Note that our PowerBI tenant is in the Australia South East region so I don't know why dates in the service are showing in US format.

 

Any advice much appreciated.

 

Thanks,

Ed

 

Desktop version:

PBI Desktop Date.PNG

 

Service version:

PBI Service Date.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
irmat Frequent Visitor
Frequent Visitor

Re: Date format - Desktop vs. Service

@saunders

Hi,

I had the same issue by using SSAS. I noticed that in SSAS the data on the data format on the date column was set to either General or short date. Setting the data format to dd/MM/yyyy fixed the issue.

Hope this helps.

8 REPLIES 8
Moderator v-sihou-msft
Moderator

Re: Date format - Desktop vs. Service

@saunders

 

In Power BI Desktop, it takes the date format of local machine.

 

5.PNG

6.PNG

 

However, I can't reproduce your issue. When I publish a report with "d/MM/yyyy" date format onto Power BI Service, it will keeps same format.

 

7.PNG

 

Can you republish your .pbix again to see if it works properlly?

 

Regards,

Highlighted
saunders Regular Visitor
Regular Visitor

Re: Date format - Desktop vs. Service

Hi Simon, thanks for your reply.  I've investigated this more and it seems that, when there is a live connection to Analysis Services or when there is DirectQuery connection to SQL Server, PowerBI displays the US format, not the local format.

 

Is there anyone else who is experiencing this?

 

Thanks!

 

Analysis Service - Import (correct)

Data Test - AS - Import.PNG

 

 

Analysis Service - Live Connection (incorrect)

 

Data Test - AS - Live Connection.PNG

 

 

SQL Server - DirectQuery (incorrect)

 

Data Test - Data Mart - DirectQuery.PNG

 

 

irmat Frequent Visitor
Frequent Visitor

Re: Date format - Desktop vs. Service

@saunders

Hi,

I had the same issue by using SSAS. I noticed that in SSAS the data on the data format on the date column was set to either General or short date. Setting the data format to dd/MM/yyyy fixed the issue.

Hope this helps.

saunders Regular Visitor
Regular Visitor

Re: Date format - Desktop vs. Service

Hey, thanks for the note, that fixed it.

LizHackett Frequent Visitor
Frequent Visitor

Re: Date format - Desktop vs. Service

Hi @irmat,

I had the same problem as @saunders (in Eastern Australia as well) and I've changed my date format under Windows Region settings to the long format dd/mm/yyyy, but still having the same issue.

Am I changing the date format in the wrong place?  If so, where should I be changing it?

 

In Query editor I changed the type to Date (as it comes through as text via a web link to a dataset from Blackbaud CRM) and getting an error on those dates in which the day is above 12. 

Picture1.jpg

 

 

 

 

 

 

 

 

 

 

 

Thanks!

irmat Frequent Visitor
Frequent Visitor

Re: Date format - Desktop vs. Service

Hi @LizHackett

Have you maybe tried the below

Capture.PNG

or changing it to English (Australia)? You will have to restart Power BI Desktop after this change.

Capture2.PNG

 

 

LizHackett Frequent Visitor
Frequent Visitor

Re: Date format - Desktop vs. Service

Hi @irmat

Thanks!! The first solution you suggested to change the date format under Modelling within Desktop  (not in query editor) to dd/mm/yyyy worked Smiley Happy
I made sure I had my location in Desktop set to Australia.

Thanks for your help!

techgeek New Member
New Member

Re: Date format - Desktop vs. Service

Thanks for the info. Its solved same issue we had in our project :-)

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 44 members 988 guests
Please welcome our newest community members: