Oct 24 2019 07:13 AM
I have Power BI report in MS Teams tab, the issue is the date format is in US on desktop version and the date format is in UK in the online Teams version. I want the format to be in UK for both.
I have checked the Teams setting in desktop and also the windows setting in for the region and confirmed it is set to the UK.
Nov 01 2019 02:45 AM
@cleirMK61 Experiencing the same problem. When opened in browser (Chrome 78.0.3904.70) I can navigate to settings via. gear icon, settings, language and changing to Norwegian it show the correct formatting. While in MS Teams the viewer that shows the PBI reports does not import these settings from the web page or the Teams client (set to Norwegian). W10 is also in Norwegian.
Nov 04 2019 12:53 AM
Hi, experiencing the same trouble with Teams Tab: when opening the rapport via the web icon, the date format is correct (Following W10 - Edge defauls settings (french in my case)); when opening tab in Teams, the date is in reverse mode (English - uk). I checked my language settings of Teams, and the dates are showing right (french) in conversations within Teams… So, it seems obvious that Teams / PowerBi is the culprit…; hope Microsoft will correct this bug soon….
Fyi, i'm using last version of Power BI Pro and Teams is up to date…..
Kind regards,
NO2CL
Nov 04 2019 01:59 AM
Dec 18 2019 09:54 AM
@cleirMK61Has there been an update/fix for this? I have just found the same issue
Jan 05 2020 01:14 PM
Feb 18 2021 04:27 PM
Apr 14 2021 12:28 AM
Apr 20 2021 02:15 AM - edited Apr 20 2021 02:16 AM
Also got this problem have added a Power Bi report to a Team and it displays the last refreshed date in the wrong format mm/dd/yyyy whereas in the Power BI web interface it is correct dd/mm/yyyy. Have checked both PC and site settings and all set to UK. What am I doing wrong or is this a bug.
Apr 20 2021 03:34 PM
@Richard Whalebelly Hi Richard, I contacted the Power BI team directly and they confirmed that this was a bug. A bug with no ETA on the fix...
The Microsoft consultant said:
"We have recommended you to post an idea , so that it would be looked into and taken into high priority to implement it in near future releases.
https://ideas.powerbi.com/ideas/"
Go Microsoft....
Aug 02 2021 06:34 PM
Aug 02 2021 06:45 PM
@KarlInOz Thanks for the plug
Aug 02 2021 07:02 PM
OK so, in the meantime I have a partial solution. This seems to work on dates in tables/matrices but not in slicers:
Ensure that your dates, in the model, are not formatted as General - they will appear good in PBI desktop but not in Teams. Instead, change them to your specific format.
So, change from this:
to this:
Aug 02 2021 07:07 PM