Forum Discussion
Power Query importing excel date field mmm-yy(Dec-21) automatically to 12/21/2022
If by "fix this" you mean you want to display it the same as in your original Excel sheet, then:
Your data in Excel is a Text string but Power Query is changing it to a Date. All you need to do is ensure PQ treats it as text.
If you examine the Applied Steps window, you will see that (probably) the second step is something like "Changed Type". If you select that step, you will see in the formula bar something like:
=Table.TransformColumnTypes(Source,{{"Date", type date}})
There may be other column names and types also in that line.
All you need to do is edit that line to change type date to type text
If you mean something else by "fix this" then please explain precisely what you want.
Hi, SaulM ;
It is very strange that you can share your excel file to remove sensitive information? So that I can test it
How to upload PBI in Community
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Looks like my work network prevents me to share or connect to any fileshare sites, Yalan. I was able to recreate the sheet from scratch and it did the same thing within Power Query. Below are random number. If you type DEC-21 (no spaces) it will recreate the issue.
Thanks!
Saul