Forum Discussion

Rosh89's avatar
Rosh89
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper 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
Icon for Community Support rankCommunity 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