Forum Discussion
Subscription report date format wrong
Hi,
How do you stop a subsription report from displaying the date format wrong in the preview image? we are in the UK and the we have a report preview on a subscription that has the date at the top. The report displays fine in desktop and the service as DD/MM/YYYY but when it apepars in people inboxes the preview image is MM/DD/YYYY. How do we stop this? my locale is set currect to UK (as it works fine in desktop and service)
Regards
Hi coatsy35,
Thank you for reaching out to the Microsoft Fabric Forum Community.
as a workaround you can convert a date column to text format but Use two separate versions.Keep the original date column (or calculated column) for all calculations and visuals needing time intelligence.
Use the formatted text version only for display purposes, such as titles, headers, or cards where date format matters (e.g., email preview in subscriptions).
If the issue still persists or the suggested workaround not suitable in your scenario then, I’d recommend raising a support ticket with Microsoft. The support team can look into the backend and provide more in-depth assistance tailored to your environment.
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket
Best regards,
Prasanna Kumar
16 Replies
Hi coatsy35 ,
- Power BI email previews are rendered on Microsoft servers that may default to US locale (MM/DD/YYYY).
- Set the dataset locale to English (United Kingdom) in Workspace > Dataset > Settings.
- Format date fields explicitly using FORMAT([Date], "dd/MM/yyyy") in the report.
- Check tenant locale settings in Power BI Admin Portal and ensure UK or user override is allowed.
- Make sure the subscription creator’s browser language is set to English (United Kingdom).
- Delete and recreate the subscription after making these changes to update the preview formatting.
Hi, on
- Set the dataset locale to English (United Kingdom) in Workspace > Dataset > Settings whihc setting is the locale? there doens't apepar to be any such setting?
where in admin do you check the lcoale or override, I can't see anyting in there either a screenshto of what to check would be useful in both cases
Go to File > Options and settings > Options > Regional Settings, and set to English (United Kingdom).
Save and publish the report again — this affects how the dataset behaves in the service.That is already set in the file
Hi coatsy35,
Thank you for reaching out to the Microsoft Fabric Forum Community. And also thanks to BhavinVyas3003 for Prompt and helpful response.
Try the fallowing suggestions to resolve the issue.
Set Regional Settings in Power BI Desktop Before publishing, go to File -> Options and settings -> Options- > Regional Settings, and choose English (UK), then re publish the report.
Check Access and Ownership of data set, Only the dataset owner or users with Admin/Contributor roles can view dataset-specific settings like refresh, parameters. Only Power BI Service Admins or Microsoft 365 Global Admins can check Tenant Settings.
After applying these changes, delete and recreate the email subscription to refresh how the preview image is generated.The below community discussion may help for your scenario.
If this information was helpful, kindly mark the response as accepted and give it a thumbs-up, so it may assist others as well.
Best regards,
Prasanna KumarHi, I am the dataset owner and admin and tenant admin.
In the dataset settings, I see no setting that relates to region or locale?
Check Access and Ownership of data set, Only the dataset owner or users with Admin/Contributor roles can view dataset-specific settings like refresh, parameters. Only Power BI Service Admins or Microsoft 365 Global Admins can check Tenant Settings.
From the other post you pointed me to:
Please try below steps:
1. Adjust the Locale Settings in Power BI Desktop: Before publishing your report, ensure that the locale settings within Power BI Desktop are set to your desired region. This can help in ensuring that the formatting aligns with your expectations.
This is already set in the file.
Hi coatsy35,
Thank you for reaching out to the Microsoft Fabric Forum Community.
as a workaround you can convert a date column to text format but Use two separate versions.Keep the original date column (or calculated column) for all calculations and visuals needing time intelligence.
Use the formatted text version only for display purposes, such as titles, headers, or cards where date format matters (e.g., email preview in subscriptions).
If the issue still persists or the suggested workaround not suitable in your scenario then, I’d recommend raising a support ticket with Microsoft. The support team can look into the backend and provide more in-depth assistance tailored to your environment.
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket
Best regards,
Prasanna KumarHi coatsy35,
Just checking, have you had a chance to open a support ticket, as suggested. If so, we'd love to hear the current status or any updates from that.
If the issue was resolved through the support ticket, it would be great if you could share the solution here as well. It could really help other community members find answers more quickly.
Warm regards,
Prasanna KumarHwo do I do that. We don't pay for support. We are on Pro per user. It wants me to select a contract for support which we don't have.
Hi coatsy35,
Thank you for following up and for being an active member of the Microsoft Fabric Forum Community.
Power BI Pro users do have access to support, but only for standard support through the Microsoft 365 admin center. However, this access is typically available only to users with admin roles (like Global Admin, Power BI Service Admin, or Support Admin) in your Microsoft 365 tenant.
If you're not an admin, you won’t be able to raise a ticket directly unless.
Your admin raises it on your behalf, or Your organization has a paid support plan (like Premier or Unified Support).
Best regards,
Prasanna KumarI am the admin. No idea how to do thats o wil ltake a look. The ycould make it clearer on the submit support page what you get for your license or tell you that you can't access it. Whast the point of having the ticketing page etc... showing on a plan that doens't have that ability. Usaual MS being stupid.
Hi coatsy35,
Thank you for reaching out to the Microsoft Fabric Forum Community.
Please refer to the threads below, which may assist you in creating a support ticket.
Thanks & Regards,
Prasanna Kumar
