Forum Discussion
Jodhvir
Jun 09, 2020Brass Contributor
Power Query error handling
Hello..
I have made a list of many urls from which I need to extract data. I made a custom function and ran it in the Power Query. As it turns out, a few urls are not correct / have changed. Now when I run the function, Power Query returns me Error 404 message. It stops the function there itself, never moving to the next row.
Is it possible that if the function encounters any error (specifically 404), it does not stop there, instead moves onto the next row.
Thank you.
3 Replies
- SergeiBaklanDiamond Contributor
Please check this post Handling 404–Not Found Errors With Web.Contents() In Power Query And Power BI
- JodhvirBrass ContributorThank you Sergei for the reply. Turns out I was using Keep Errors at the wrong step. Once it was at the right order, everything worked out perfectly. Your help has saved me a major time in the past few days. Thanks again
- SergeiBaklanDiamond Contributor
Jodhvir , glad to help