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.

View solution in original post

10 REPLIES 10
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,

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.

View solution in original post

Highlighted
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 :-)

MatE Frequent Visitor
Frequent Visitor

Re: Date format - Desktop vs. Service

Hi All,

 

I went through all the changes that you have mentioned here. However, Power BI service did not display the date format(dd/mm/yyyy) until I change the browser language. 

In this case, I was using Chrome. 

Chrome -> settings -> Default browser -> Language -> Add language -> Make sure that you have the correct language setting at the top. 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 6 members 1,013 guests
Please welcome our newest community members: