I am picking the csv file from a folder which has a time field of more than 24 hours(format->37:30:55). But when I am using power query(not Power BI) time format is getting changed.
Eg: In my source file I have time as 46:33:10 but in power query it is loading as 1/2/1904 10:33:10 PM.
Now, I want 46:33:10 to be loaded/converted in my power query. I am not using Power BI to use any DAX Query. I have also tried converting it to Duration but it didn't help