Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello.
I have the following data coming in from a dataflow.
I need to have this as a Date field and in the UK format.
I change the Column to a date column, then i changed the locale to US and it gives me back the below
Why are some values coming back as errors?
When i click on an error (for e.g. the first one it says "DataFormat.Error: We couldn't parse the input provided as a Date value.
Details:
1/31/2023"
In Power BI Options, my current File regional settings are set to English (United Kingdom)
Can someone please assist?
Thanks
Solved! Go to Solution.
Hi @PPStar
You can change the locale from English (United States) to English (United Kingdom) through the following path:
File → Options and Settings → Options
will get you the screen like below where you can change your locale.
Best regards,
Hi @PPStar
You can change the locale from English (United States) to English (United Kingdom) through the following path:
File → Options and Settings → Options
will get you the screen like below where you can change your locale.
Best regards,
That worked. Thank you
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |