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 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

Need Help

v-luwang-msft
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

8 Replies

Anonymous
Not applicable
4 years ago
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
  Helper I
  4 years ago
  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
    Helper II
    4 years ago
    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.
v-luwang-msft
Community Support
4 years ago
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
TEST111.pbix39 KB
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
  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
    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