Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.
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.
Any advice on how to get the Excel output to equal the service version of date and times would be appreciated.
Solved! Go to Solution.
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
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.
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).
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
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.
User | Count |
---|---|
39 | |
31 | |
29 | |
25 | |
24 |
User | Count |
---|---|
53 | |
53 | |
35 | |
31 | |
28 |