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 ...
Dataflow
Need Help
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?

 

  • GilbertQ's avatar
    GilbertQ
    Super User
    7 years ago
    Not off the top of my head, but I am sure that there is a way to get this done.
    • cnschulz's avatar
      cnschulz
      Helper IV
      7 years ago

      Anyone? I must be missing something basic here.

      GilbertQ wrote:
      Not off the top of my head, but I am sure that there is a way to get this done.

       

  • cnschulz's avatar
    cnschulz
    Helper IV
    7 years ago

    Hi, 

     

    The very first source line of that linked page is identical to mine 

    Source = Web.Page(Web.Contents("http://..." 

     Therefore, it should require a web gateway as well. 

     

    Has anyone processed web (http) data in a report on the powerbi service without a gateway? Is so please detail the steps.