Forum Discussion

MiksLacis94's avatar
MiksLacis94
Frequent Visitor
3 years ago
Solved

Data refresh failing in Power query

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 ...
Need Help
  • MiksLacis94's avatar
    MiksLacis94
    3 years ago

    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. 

MiksLacis94's avatar
MiksLacis94
Frequent Visitor
3 years ago

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.