Forum Discussion

Rosh89's avatar
Rosh89
Helper I
4 years ago
Solved

date format changes in subscription email preview

Hi,  I would like to have the date format in DD-MM-YYYY. This format shows correctly both in desktop and service. But when an email subscription is sent the date format changes to MM-DD-YYYY and tha...
Need Help
Rosh89's avatar
Rosh89
Helper I
4 years ago

Hi v-luwang-msft ,

 

Thanks for the detailed explanation Lucien. What you shared definitely works on table visuals. But the same does not work on date slicers. 

You can see in the image from the subscription received the order of the date was changed to MM-DD-YYY which is what I want to resolve to DD-MM-YYYY.

 

Best Regards,

Roshan

v-luwang-msft's avatar
v-luwang-msft
Community Support
4 years ago

Hi Rosh89 ，

this is expected behavior:

The reason is this:

  • subscriptions are executed by the Power BI service as a background job, using the owner's locale.
  • The owner locale is the one specified in the settings as one of the 44 currently supported languages: https://docs.microsoft.com/en-us/power-bi/fundamentals/supported-languages-countries-regions
  • When language=(browser default) is selected, the backend cannot use the browser value because browser may have other/different sets of supported languages. As a consequence, the backend will set the user setting to default, which is American English.

And refer the following article:

Troubleshoot subscribing to dashboards and reports - Power BI | Microsoft Docs

 

 

Best Regards

Lucien

  • Rosh89's avatar
    Rosh89
    Helper I
    4 years ago

    Hi v-luwang-msft ,

     

    Understood now. Powerbi service accepts US english only and it can only be corrected when I change to another language which follows DD-MM-YYY format.

     

    Many thanks!

     

    Best Regards

    Rosh

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Please kindly vote for that change idea to support dd/mm/yyyy in subscription email preview: 

    Microsoft Idea