Forum Discussion

pankajj's avatar
pankajj
Helper III
4 years ago
Solved

Web.BrowserContents Refresh Error Power BI Services

Greetings PBI Experts!   I am using the following query to extract shipping data. It works fine on the Desktop version but not on Power BI services.   Can someone please advise how to change this...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi pankajj 

    Your table is based on query and it is a dynamic data source. If I add ID in code directly, it seems that we could refresh this report with gateway in Power BI. Try to use parameter to get dynamic tracking id. You can add all ids you need in parameter list, and you can change the id you get by parameter in Desktop and Service.

    let
Source = Web.BrowserContents("https://www.ship24.com/tracking?p=" & #"Tracking ID"),
#"Extracted Table From Html" = Html.Table(Source, {{"TrackingID", ".md\:text-2xl"}, {"Status", ".md\:w-34pc"}, {"Courier", "APP-USER-COURIER-LABEL"}, {"Origin", ".j-sh:nth-child(1)"}, {"Destination", ".j-sh:nth-child(3)"}, {"Delivered on", ".capitalize"}}, [RowSelector="USER-PARCEL-CARD"])
in
#"Extracted Table From Html"

    Then download a gateway and configure the credential. Then you can schedule refresh your report.

    For reference: 

    What is an on-premises data gateway?

    Configure scheduled refresh

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi pankajj 

Is "3407985361" the TrackingID in your code? Do you want to get HTML table from web?

 

Based on my test, if you want to get the HTML table from web, you need to use Web.BroswerContents() which returns html, Web.Contents() will return a binary result.

If you nest Html.table() outside Web.Contents(), you will always get an empty table whatever your web address.

When you use the web connector to extract data, you would find that it also use Web.BroswerContents() instead of Web.Contents().

 

In addition, about Dynamic data source using Web.contents, you can refer: Dynamic Web.Contents() and Power BI Refresh Errors 

 

Here is a blog with similar issue like yours, I hope it could help you.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

pankajj's avatar
pankajj
Helper III
4 years ago

Anonymous 

Thanks so much for your help. I will try your method.

I am able to get the data using Web.BrowserContents in Power BI Desktop but not in Power BI Service.

Can you suggest, how to edit the following query to make it refreshable in Power BI Service to get the same result using Tracking ID : 3407985361

I am expecting, following result:

 Looking forward to hearing from you.

Thanks so much for your help.

Best regards,

Pankajj

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    The service seems to be malfunctioning at the moment - I get a 500 error when querying by that ID.

    • pankajj's avatar
      pankajj
      Helper III
      4 years ago

      lbendlin & Anonymous 

      Please find below a link to the Power BI file. I am not getting any error with the function fxtracking.

      https://we.tl/t-GPGCS9xLeQ

      Hoping, you would be able to help in editing the query by using RelativePath, Query and replacing Html.Table to let it refresh automatically. without the below error.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi pankajj 

        Your table is based on query and it is a dynamic data source. If I add ID in code directly, it seems that we could refresh this report with gateway in Power BI. Try to use parameter to get dynamic tracking id. You can add all ids you need in parameter list, and you can change the id you get by parameter in Desktop and Service.

        let
Source = Web.BrowserContents("https://www.ship24.com/tracking?p=" & #"Tracking ID"),
#"Extracted Table From Html" = Html.Table(Source, {{"TrackingID", ".md\:text-2xl"}, {"Status", ".md\:w-34pc"}, {"Courier", "APP-USER-COURIER-LABEL"}, {"Origin", ".j-sh:nth-child(1)"}, {"Destination", ".j-sh:nth-child(3)"}, {"Delivered on", ".capitalize"}}, [RowSelector="USER-PARCEL-CARD"])
in
#"Extracted Table From Html"

        Then download a gateway and configure the credential. Then you can schedule refresh your report.

        For reference: 

        What is an on-premises data gateway?

        Configure scheduled refresh

         

        Best Regards,
        Rico Zhou

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.