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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
SteveD
Advocate II
Advocate II

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
v-rongtiep-msft
Community Support
Community Support

Hi @SteveD ,

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 Po...

 

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 II
Helper II

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).

v-rongtiep-msft
Community Support
Community Support

Hi @SteveD ,

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 Po...

 

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors