Power Query Error Handling?

[Charley]

When I'm using a parameter table to grab web data, PQ aborts when it finds a 404 error. Is there a way to set up something like "On Error Resume Next" in PQ so it would give me its successful results?

Thanks!

Charley

[Rudi]

The typical ways of handling this is to either use filters to eliminate the records producing the errors, or if this is not possible, to use the Try...Otherwise statement to provide an alternate value if an error occurs. If you can implement either of these in the query steps before the expand step, it should resolve your issue. All this advice is theoretical as I don't have insights into your query design. If it makes sense and seems a viable option, give either a try.

For details on Try...Otherwise, see:

- https://msdn.microsoft.com/en-us/library/mt186368.aspx

- https://blog.gbrueckl.at/2013/12/err...n-power-query/

[Charley]

Rudi,

Thanks for the links!

Charley