Forum Discussion
Solved
Servicenow Date DataFormat.Error
Good day, I have just started using powerbi and a novice. I currently have powerbi connected to Servicenow change table. some dates come through and others give me an error. Has...
HI antz1703
The format of the date should be "YYYY-MM-DD" , the format of your date is "YYYY-DD-MM" , you need to transfer the date to "YYYY-MM-DD" in your data source, then connect it in power query.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI antz1703
The format of the date should be "YYYY-MM-DD" , the format of your date is "YYYY-DD-MM" , you need to transfer the date to "YYYY-MM-DD" in your data source, then connect it in power query.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.