Forum Discussion
Date Format [DDMMYYYY] Not Detecting Properly
I've seen similar topics posted on this forum, but haven't been able to create a working solution. What Im lookin for is to import data in its [DDMMYYYY Time] format and have PBI read it as a correct...
In the Power Query Edit ,Try to change the Data type using Locale. for idea see the screeshots. This approach should help you,
Thanks for the response, but that didn't solve my problem. Even setting to English (India) is still interprets 2/7/2019 as February 7, 2019. No matter what location I set it to it reads it that way even though that date is meant to be July 2, 2019.
Then Select English US . It can be resolved else share the few rows of Date Field so that I will creat video for you!