Data refresh failing in Power query

[MiksLacis94]

Hi everyone,

I have an issue with a company file while trying to update the data. I am not the owner of the file nor I created it but I am trying to figure out why it is not working. 

Basically the idea is that our source files are - Employee hours registration file, warehouse volumes files. The file being updated is a Performance tracker for our site but it keeps getting the attached error. I've checked the source file for wrong values but everything seems correct to me.

Thanks in advance if anyone can help me with this.

[MiksLacis94 · Accepted solution]

I've found the issue and fixed it and everything is updating correctly now. As the source file actually has data from the past 18 months, it has around 40k lines so finding the issue cell was a pain. I used the formula errors option in Excel which found a few cells from 2021 that had issues and deleted those. However I am almost certain they were not edited recently so not sure why the Power query suddenly failed. 

[pratyashasamal]

Hi @MiksLacis94 ,

If updating the version of the application doesn't solve this problem, you could consider removing the applied steps one by one from the last step to check whether some specific transformation step caused this error. 
Thanks ,
Pratyasha 

If this post helps, please Accept it as the solution to help other members find it.