Forum Discussion
Subscription report date format wrong
- Anonymous1 year ago
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
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?