Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
Hello,
I have a reporter that displays a date with the following format dd / mm / yy, but when uploading it to the workspace it appears as mm / dd / yy, how can I solve it?
Computer:
Workspace
Regards,
Xavi
Solved! Go to Solution.
Hi, there is something that depends on regions. Browser and Power Bi Desktop. If you have "default" data types and formats they will render depending on the configuration of the tools. If you force your browser to your country (that probably shows dd/mm/yyyy), you will fix it.
You can also force it in Power Query transform data. You can select an specific format before loading data in order to avoid default date. Just do as the picture shows and then pick "Year" and your wished format:
UsingLocale
Hope that helps,
Happy to help!
Hi, there is something that depends on regions. Browser and Power Bi Desktop. If you have "default" data types and formats they will render depending on the configuration of the tools. If you force your browser to your country (that probably shows dd/mm/yyyy), you will fix it.
You can also force it in Power Query transform data. You can select an specific format before loading data in order to avoid default date. Just do as the picture shows and then pick "Year" and your wished format:
UsingLocale
Hope that helps,
Happy to help!
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 29 | |
| 23 | |
| 17 | |
| 16 | |
| 14 |