Results 1 to 3 of 3

Thread: Power Query Error Handling?

  1. #1
    Acolyte Charley's Avatar
    Join Date
    Jul 2017
    Posts
    62
    Articles
    0
    Excel Version
    365

    Power Query Error Handling?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Conjurer Rudi's Avatar
    Join Date
    Jan 2014
    Location
    Cape Town, RSA
    Posts
    134
    Articles
    0
    Excel Version
    Excel 365 ProPlus
    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/
    Regards,
    Rudi
    www.eileenslounge.com

  3. #3
    Acolyte Charley's Avatar
    Join Date
    Jul 2017
    Posts
    62
    Articles
    0
    Excel Version
    365
    Rudi,

    Thanks for the links!

    Charley

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •