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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
belvoir99
Resolver III
Resolver III

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 III
Resolver III

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 III
Resolver III

@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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors