none
How to ignore Web.Contents error on Power Query

    Question

  • How to ignore Web.Contents methos error on Power Query function ?

    Web.Contents make auth error on my Urls, sometime.
    I want to ignore auth error, and skip.

    Currently Power Query confirm collect auth information of web site, and cannot ignore.

    Regards,
    Yoshihiro Kawabata

    Wednesday, September 04, 2013 6:56 AM

Answers

All replies

  • Hi Yoshihiro,

    Are you trying to:

    1. Ignore the error and display whatever is on the webpage anyway
    2. Ignore the error and continue to run the mashup differently

    #1 is not supported, #2 can be done by wrapping with a try otherwise.

    Thanks,
    M.

    Monday, September 09, 2013 5:21 PM
    Owner
  • I try #1, #2.

    For example:
     2 site error in 1,000 site.
     2 site error reasons is maintenace, and set BASIC Auth mode for only administrator.
     I want Power Query ignore 2 site, and get 998 site Web.Contents. 

    Regards 

    Monday, September 09, 2013 10:20 PM
  • Hi Yoshihiro,

    Do you get top-level errors or error in some cells? (i.e. if you're using Web.Contents([URL]) as a custom column, where URL is another column in the table.

    If you get the errors at cell level, then you can use "Table.RemoveRowsWithErrors" library function to exclude the rows with errors in those columns.

    Thanks,
    M.

    Tuesday, September 10, 2013 5:52 PM
    Owner
  • Hi Migue,

    Dialog "Access Web Content" appear at Web.Contents([URL]),
    which [URL] need to BASIC Auth.
    I want to skip the URL without dialog.

    Regards,
    Yoshihiro Kawabata.

    Tuesday, September 10, 2013 11:03 PM
  • Is this still an issue?

    Thanks!


    Ed Price, SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!

    Wednesday, September 18, 2013 8:38 PM
    Owner
  • No issue.

    Regards,
    Yoshihiro Kawabata
    Wednesday, September 18, 2013 10:38 PM