Servicenow Date DataFormat.Error

[antz1703]

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.

[Anonymous · Accepted solution]

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.