The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
I have a multiple pbix's that are published to our service fine. However some users see the date format in US format instead of UK format. I can't figure out why this is. The pbix has it's region set to UK. Their windows enviroment is all configured for UK region and English UK language on all users PC's. Their browser language is configured to UK and English UK. There are no US settings anywhere. Most users see it with UK date format. I'm assuming this is a O365 setting for the user somewhere thats not correct.
How do I change this as office admin? It must be a tennant setting somewhere. As if I log into his Power BI service on my PC through the same browser I use, he has US dates and my copy has UK dates - so defintiely AD or PowerBI service setting. Is there a way I can check all users and globally change? we only work in the UK
Any help greatfully received.
Solved! Go to Solution.
Hi @coatsy35 ,
For all Microsoft 365 services (including OneDrive For Business, Delve, and SharePoint Online), you can change the language and regional settings at the user level in a Cloud identity or Synchronized identity model by using Microsoft Graph PowerShell.
For more details, please refer: Set language and regional settings for Microsoft 365 - Microsoft 365 | Microsoft Learn
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Fast forward 6 months and still finding this dispute my efforts. Why can the pbix not keep it UK style if it was created that way? I've just given out a new dashboard today and half the users are reporting the date slicers are in US format, dispute the data hosted in the UK and me designing it with UK date format. Any other suggestions? On the users in question their windows languages UK English, their browser is in UK English and as said we have it hosted on UK London, so why are they seeing US date formats? There office account is also set to UK english
Hi @coatsy35 ,
First of all thanks to @bhanu_gautam for the quick reply. I would like to make some additions:
As a global administrator of PBI, you can check the Power BI Service settings for the affected user:
Starting inside the Power BI service (app.powerbi.com)
1) Click on the gear icon in the top right corner
2) Click on Settings
3) Select Language
4) Select Default Browser Language
5) Go to your browser settings and set English as your browser's default language.
For more details, please refer: Solved: Date displayed in american format - Microsoft Fabric Community
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That is already set. It turns out it is due to certain users having thei display language and region format set to US int he ir office account. Non of them even knew where the setting was, so I assuem it was done 8-9 years ago when we first went with O365. These are peopel who are not technically minded. I can't check all acocutns as I can't see a way to do so.
Hi @coatsy35 ,
For all Microsoft 365 services (including OneDrive For Business, Delve, and SharePoint Online), you can change the language and regional settings at the user level in a Cloud identity or Synchronized identity model by using Microsoft Graph PowerShell.
For more details, please refer: Set language and regional settings for Microsoft 365 - Microsoft 365 | Microsoft Learn
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@coatsy35 Hi the reason might be ;- Power BI service operates in the UTC time zone, and evaluates all locale based time functions in that time zone. Power BI Desktop evaluates them according to the locale of the user.
Proud to be a Super User! |
|
That may be, but not sure how. As I canot log into two different PB service accounts on my PC and have different date formats shown in both. It's to do with the user acocunt screen language and region format. Howver the only way I can see to change this is to do it for each user individually. Hopign their is a way to change them all through O365 admin
User | Count |
---|---|
36 | |
15 | |
12 | |
11 | |
9 |
User | Count |
---|---|
46 | |
44 | |
19 | |
18 | |
18 |