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.
Hi everyone,
I've created my report in power bi desktop that is using Direc Query.
I have Date slicer in my report and the display format is Australian format (Exactly what I need). for example "31/12/2016"
The Date Value in SQL server database is like "2000-01-24 00:00:00.000" and data type for this column is Datetime.
The language setting in my computer and also in power bi desktop is "English(Australia)" and language in power bi service is English.
After publishing the report ,I see Date format will change to US format, it is "12/31/2016".
Do you know what is the reason and how can I fix it please?
Thanks,
Emma
Solved! Go to Solution.
If you are hosted in US, it will always use US date format on Power BI Service. To workaround this issue, you can try to set the default language on Browser. Please refer to a similar thread below:
https://community.powerbi.com/t5/Desktop/Date-format-changing-desktop-to-web/td-p/117204
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.