Forum Discussion
Date automatically updated with wrong dat
I am facing a strange problem with dates in my report. I am fetching data of type date from Excel sheet to create PowerBI reports. Below is the sample data with column header "Month-Yr" Month-Yr ...
I think it might have to do with some regional settings in either PBI or Excel, although I'm not sure about how to proceed from there.
I think it might have to do with some regional settings in either PBI or Excel, although I'm not sure about how to proceed from there.
That worked! I turned off and then turned on Data load> Time Intelligence > Auto Date/Time option and all the dates in my PowerBI reports reset to proper format.
For future reference, it is good practice to turn off the "Auto Date/Time" option, as that can and likely will interfere with your usage of date/time values.