Hi,
I'm doing the Power Query course, lesson 4.03. When using Locale as instructed in the course I get an error message:
"DataFormat.Error: We couldn't parse the input provided as a Date value.
Details: 01-29.2015"
I'm in UK.
No other steps applied to the query.
Thank you
Hi Carolina,
Welcome to the forum! Did you choose Data Type 'Date' and Locale 'English (United States)? I just tested it again here and it works with those settings.
Mynda
As I'm in Uk I put English UK. I just did it again selecting the English United States, and it worked. Does that mean when you are selecting Locale you are telling the Power Query the format that the data is already in, not the format that you want the data do be in? So is the dd/mm/yyyy the only date format in Power Query or you can have others as well ( like in excel).
Thank you.
Yes, you're telling PQ the format the data is in. PQ already knows your locale so it knows the format you want it in.
In terms of formatting dates, that part is still done in Excel like it always is. Power Query is not where you format, it's where you clean the data ready for loading to Excel where you can start altering the formatting.
Hope that clarifies things.
Mynda
