Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
1: I open an app in the power bI tenant,
2: I then Click on å table visual, on the the 3 dots in the top-right corner and choose export data
3: I Choose Date with current layout
4: I open the file in excel.
Issue:
The date format changes from dd.mm.yyyy to m.d.yyyy in excel (the cells in excel is formatted automatically as custom)
It shows correctly in power bi tenant, I changed the language in settings in power bi tenant to norwegian.
The regional format on my computer is norwegian with format (dd.mm.yyyy)
In excel I run english as display language, but nNorwegian as authoring and proofing language
I want to avoid formatting the date as text in power bi.
Any suggestions?
Best regards Terje Fjeldstad
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Issue is resolved by using the 14.03.2001 (dd.mm.yyyy) format in pleace of the *14.03.2001 (Short Date) format.