Forum Discussion
Date Format Error
GK600 Sorry mate not able to figure how to get the dates to US format, I think it all comes down to the system format, becuase it works on my system with us format but not on the one with UK format, one thing you could do is to change the date format once you load the data from the Power Query to the data model.
Not sure if reducing the source file size helps in quick loading of the data, but if you can then you should load the data to a database. like SQL server.
Thanks AntrikshSharma for your response,
I don't have sql server facility as of now. I dont know how to use that either 🙂 but I think I could learn if available and useful.
I didn't know that I could simply change the date format like this in the data model so my some of the issues could be resolved with this. However, I mainly had to transform data based on this date column within Power Query. I am starting to consider different manual options though if we can't figure out. I will also raise a query with Microsoft if this is an issue as suggested by Gregg.
Thansk anyways for your help. Much appreciated.
regards,
Gaurav