Paginated report Date and Time format changes when output to excel

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.