Forum Discussion
Date/Time data tipe values in error
Hi, I'm building a report where I need to filter my visuals by the date and time a sales document was created on. I extract this information exactly the same everyday and upload it to powerbi wi...
Anonymous , is this date format is different from what you were getting in past?
Is you default date format dd/mm/yyyy and you start getting the mm/dd/yyyy
Open power query and check for additional error details
No, the date format is the same - mm/dd/yyyy - as it was before the error. I checked in a copy of the same file and all date formats are the same but only one of them shows the error after the refresh of the data. And the data is uploaded from the same source.
The details of the error on power query are what I wrote above in bold, it seems to be that time is showing before the date but I didn't change that, if this makes sense.
Thank you for your help