date format changes in subscription email preview

[Rosh89]

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 thats what the users see in the image which they receive by email. 

Can someone please help with this issue? Irrespective of the region I would like the users to see date in DD-MM-YYYY in the email subscription image. 

Regards

Rosh

[Rosh89]

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 · Accepted solution]

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

[Azure_newbie]

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

Microsoft Idea

[Rosh89]

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

[v-luwang-msft]

Hi @Rosh89 ，

How did you get "DD-MM-YYYY"?You could try like me the below:

visual:

After publish:

Then   subscription:

language setting:

You could test  on the pbix file I shared.

Best Regards

Lucien

[Anonymous]

Hi,

you can make the change in your locale settings.

Below link might help :

https://www.mssqltips.com/sqlservertip/6834/power-bi-service-date-formats/

Please like my answer in case it helped you out! 

Have a great day!

[Rosh89]

Hi, 

I tried everything in the link. Changed language settings to english uk in chrome and powerbi service (default browser language) It still doesn't work. Somehow the date format changes to US format in the subscription image. Even tried changing language settings in outlook, still didnt work.

[BGB]

Hi @Rosh89 

What I did first is change my browser to English UK and moved it to the top. Then I went to Power Service and change my language to default (not English).

This solved it for me.