Forum Discussion

myriamouan's avatar
myriamouan
Regular Visitor
4 years ago
Solved

Replace Web.BrowserContents with Web.Contents

Hi,    I am working on a dashboard that I would like to publish. I would also like to set a scheduled refresh for it. All of my data is currently sourced from the Web. And apparently it is not poss...
Need Help
  • KNP's avatar
    KNP
    4 years ago

    Hi myriamouan, 

     

    This one's got me curious and unfortunately I seem to be running into the same dead ends as you.

    I have done a lot of searching with no definitive answers but I suspect it is down to the use of JavaScript or other website specific formatting/design on that site.

    One option which I assume you've already thought of and are probably trying to avoid...

    • Install a Gateway so you can use the Web.BrowserContents() to still schedule a refresh.

    Another possibility I've found is to use the RSS feed link but I don't think it contains all of the same info...

    let
  url = "https://ir.tevapharm.com/rss/pressrelease.aspx",
  source = Binary.Buffer(Web.Contents(url)),
  #"Imported XML" = Xml.Tables(source, null, 1252),
  channel = #"Imported XML"{0}[channel],
  item = channel{0}[item],
  #"Changed Type2" = Table.TransformColumnTypes(
    item,
    {
      {"title", type text},
      {"description", type text},
      {"link", type text},
      {"pubDate", type datetimezone}
    }
  )
in
  #"Changed Type2"

     

    Here's a similar thread which also doesn't seem to be solved (it is marked as solved but I suspect that is down to the CST member marking it as solved and not the OP)...

    https://community.powerbi.com/t5/Power-Query/No-content-with-Web-Contents-vs-Web-BrowserContents/td-p/1808065 

    I'll keep looking to see if I can find any other options but let me know if any of this helps.

     

lbendlin's avatar
lbendlin
Super User
4 years ago

There is not really a need to concatenate the URL like that - unless you are using other parameters which might cause your refresh issues.

 

Try this version:

let
    Source = Web.BrowserContents("https://ir.tevapharm.com/news-and-events/press-releases/default.aspx"),
    #"Extracted Table From Html" = Html.Table(Source, {{"Column1", ".module_date-text"}, {"Column2", ".module_headline-link"}}, [RowSelector=".module_item"])
in
    #"Extracted Table From Html"