cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
belvoir99
Resolver I
Resolver I

Export to PowerPoint (via menu or via subscription): front page contains US date format and UTC time

All the pages in my PowerPoint export are correctly formatted as UK/Australia date format - dd/mm/yy. However, there a front page attached to the PowerPoint which adds in extra date/time information: last data refresh and downloaded at. e.g. 

belvoir99_0-1638371977979.png

is there a way of changing the US date format, and also using local time?

 

BTW, my office 365 account is set to:

belvoir99_0-1638373010542.png

 

6 REPLIES 6
v-xiaoyan-msft
Community Support
Community Support

Hi @belvoir99 ,

 

Have you opened a support ticket to seek a dedicated engineer to solve this problem for you based on the suggestion?

Any progress on this issue? If you would like to share any solutions or ideas about this issue that would be great!

 

Hope it helps,


Community Support Team _ Caitlyn

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

 

belvoir99
Resolver I
Resolver I

Thanks for your help @GilbertQ and @v-xiaoyan-msft but I don't think either of your answers resolve it. 

 

The front page of the Power Point is generated, not in the report, but by the Power BI Service's PowerPoint creation system. It is a page stuck on the front of the report when you run a subscription for PPTX or just export to PPTX. The Regional Settings under 'Current File' of the Options in the PBIX are set to English (UK), therefore it can't be affecting the date format. No data in the model, as far as I can tell, would impact this either.

 

I did find this article which matches to @v-xiaoyan-msft suggestions:

https://nform.com.au/how-to-change-the-date-format-in-the-power-bi-service/

So I:

1. changed Language in the Service from English (aka US English, doh) to Browser Default.

2. checked that the Language in the Chrome browser settings was set to UK (same as Australia in terms of date format)

 

Neither change helped.

 

The time is sadly ignored - you just get UTC. The browser setting is irrelevant. I changed it from UK to Australia and the time didn't change. The date is also (I suspect) the UTC date and not the local date. Currently the time in Melbourne Australia is 11 hours ahead of UK (which is currently the same as UTC) and that makes the current date 10 December (as it is just after midnight). However the front page still says 9 December.

 

The date format is set to US no matter what the version of English is set in the browser when you have 'Browser Default' set in the language settings of the Power BI Service. 

 

You can't even suppress the front page either - which would be a 'solution' of some sorts!

 

@v-xiaoyan-msft - shall I raise this as a bug if you don't have any other suggestions? 

Hi @belvoir99 ,

 

We suggest that you can create a support ticket and we will have an engineer dedicated to following up on your problem. If you’re a Power BI Pro customer, support is included at no additional charge. 

 

Reference: How to create a support ticket in Power BI - Microsoft Power BI Community

 

Hope it helps,


Community Support Team _ Caitlyn

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

 

 

v-xiaoyan-msft
Community Support
Community Support

Hi @belvoir99 ,

 

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thanks in advance for your kind cooperation!

 

If that does not solve it, did you try setting the browser language to English (Australia) and then setting the language of the Power BI service as the default browser language. Then re-export to PowerPoint to try.

 

Hope it helps,


Community Support Team _ Caitlyn

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

belvoir99
Resolver I
Resolver I

@GilbertQ thanks for replying! I'll check these suggestions out and let you know. 

 

 

GilbertQ
Super User
Super User

Hi @belvoir99 

 

I would check in the date formatting settings in Power BI Desktop by going into the Model view?

 

Also to get the local time, you would need to create a new column or a table in Power Query and use the following: 

 

Power BI – Create Last Dataset Refresh Date - Reporting/Analytics Made easy with FourMoo and Power B...





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

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors