Forum Discussion
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 anyone else had this issue or can steer me in the right direction, your help will be approeciated.
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.
1 Reply
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.