Forum Discussion
Subscription report date format wrong
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,
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 Kumar
Hi, 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.