Forum Discussion

cnschulz's avatar
cnschulz
Helper IV
7 years ago

Gateway needed for web data ?

Hi, 

 

I have created a simple test report that gets data from a publicly available website. It simply gets the current weather from a provider and shows a graph over time. 

 

When the report is loaded to app.pwerbi.com, the dataset created cannot be refreshed as it stated I need a data gateway for this. I was of the belief that for direct connect to the web I did not need a gateway.

 

Could someone confirm this? Is there a way for me to source data from the web without a gateway?

 

Cheers

 

Dataflow
Need Help

9 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    7 years ago
    Hi there

    It depends on how the underlying M Code is being used.

    I cannot recall off the top of my head, but I am certain there are different ways.
    • GilbertQ's avatar
      GilbertQ
      Super User
      7 years ago
      Hi there

      I got this from a good friend of mine

      Web.page function needs gateway. If you use web.contents you won't need it.

      So just check the underlying M Code.
      • cnschulz's avatar
        cnschulz
        Helper IV
        7 years ago

        Thanks for your quick reply.

        I am using the "out of the box" web data source. When I add my URL the following code is added as a source.

        = Web.Page(Web.Contents("http://www.bom.gov.au/tas/observations/tasall.shtml"))

         

        If I remove the "Web.Page()" and leave the Web.Contents, I am shown an icon of the website and my only option is to click to expands the data, which regenerates the Web.Page() wrapper.

         

        When I attempt to set up refresh on the generated dataset, i am prompted to use a gateway. :(

         

        Any ideas?