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...
  • KNP's avatar
    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.