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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

Paginated report Date and Time format changes when output to excel

Hi there,

I created a paginated report in the service from an existing report data set which I then created a subscription for. The output for the subscription is excel.

In the report, I use date and time fields which have been converted from UTC time to Australian Daylight Saving Date and Time. As the screenshot below indicates the report presents the date and the times as expected.

SteveD_0-1696460297361.png

However, as per the following screenshot, when the subscription is received, the dates are in US format and the time is in a decimal format that can't be converted back to a time.

SteveD_1-1696460537737.png

Any advice on how to get the Excel output to equal the service version of date and times would be appreciated.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Anonymous ,

The Excel output format uses the default US format for dates and numbers. This can cause problems when the date format is different from the US format, such as dd/mm/yyyy, or when the time format is not hh:mm:ss.

 

One possible workaround is to use a different output format for your subscription, such as PDF or PowerPoint, which should preserve the formatting of your report.

 

Another possible workaround is to use custom expressions in your report to format the date and time fields as text, so that Excel does not try to convert them to its own format. For example, you can use the FORMAT function and the Excel-style formatting to format your date and time fields as text.

Email subscriptions for reports and dashboards in the Power BI service - Power BI | Microsoft Learn

Paginated reports in the Power BI service - Power BI | Microsoft Learn

Solved: Format number in paginated report - Microsoft Fabric Community

E-Mail Subscriptions for Paginated Reports is Now Available | Microsoft Power BI Blog | Microsoft Power BI

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details.

 

Best Regards
Community Support Team _ Rongtie

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

 

 

 

 

 

View solution in original post

2 REPLIES 2
Linnil
Helper III
Helper III

Thanks for the info about how to solve this problem.
BUT crazy that it exists in the first place.
C'mon, why are we not allowing for these differences in the reporting??? It's so frustrating!
(Not your fault, I just don't understand why this kind of stuff is not supported).

Anonymous
Not applicable

Hi @Anonymous ,

The Excel output format uses the default US format for dates and numbers. This can cause problems when the date format is different from the US format, such as dd/mm/yyyy, or when the time format is not hh:mm:ss.

 

One possible workaround is to use a different output format for your subscription, such as PDF or PowerPoint, which should preserve the formatting of your report.

 

Another possible workaround is to use custom expressions in your report to format the date and time fields as text, so that Excel does not try to convert them to its own format. For example, you can use the FORMAT function and the Excel-style formatting to format your date and time fields as text.

Email subscriptions for reports and dashboards in the Power BI service - Power BI | Microsoft Learn

Paginated reports in the Power BI service - Power BI | Microsoft Learn

Solved: Format number in paginated report - Microsoft Fabric Community

E-Mail Subscriptions for Paginated Reports is Now Available | Microsoft Power BI Blog | Microsoft Power BI

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details.

 

Best Regards
Community Support Team _ Rongtie

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

 

 

 

 

 

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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