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.

     

pankajj's avatar
pankajj
Helper III
4 years ago

lbendlin 

 

Thank you very much for your help.

 

Web.BrowserContents does not refresh in the Power BI Service.

 

I replace it with Web.Contents, it works but it shows empty table on Invoked Function.

 

Please try this with sample tracking id: 3407985361.

 

I believe the error is due to the subsequent steps:

 

#"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"

 

Kindly check.

 

Thanks a ton.

 

Best regards,

 

Pankajj