Trouble avoiding gateway installations for scheduled refreshes

[mow700]

Hey community, I'm having some trouble configuring my datasets to use the Gateway connection = Connect directly setting.

My requirements specify I need to avoid using a gateway unless the dependency is definitely required.  I'm using Get Data > Web to retrieve my data from public websites using anonymous authentication.

My report has been refreshing for some time as expected using the following connection:

let
    Source = Xml.Tables(Web.Contents("http://www.astrology.com/us/offsite/rss/daily-horoscope.aspx")),

Today I added a new dataset, again using Get Data > Web to retrieve my data.  After publishing my changes, I am unable to refresh the dataset from the web service, I receive an error stating that a gateway is required.  This is the new connection, it's syntax is similar but not identical:

let
    Source = Web.Page(Web.Contents("http://www.rssweather.com/wx/us/wa/cottage%20lake/wx.php")),

I removed the new dataset and republished, refresh works again as expected.  Scratching my head, I created 2 simple repro .pbix files to demonstrate the problem.  Here is a look at the dataset settings pages for both:

Have any of you overcome problems like these and willing to offer suggested approaches to avoid the gateway?

Anyone have a point to the features / limitations of Dataset.Settings.Gateway connection = Connect directly?

[mow700]

Hey community, I'm having some trouble configuring my datasets to use the Gateway connection = Connect directly setting.

My requirements specify I need to avoid using a gateway unless the dependency is definitely required.  I'm using Get Data > Web to retrieve my data from public websites using anonymous authentication.

My report has been refreshing for some time as expected using the following connection:

let
    Source = Xml.Tables(Web.Contents("http://www.astrology.com/us/offsite/rss/daily-horoscope.aspx")),

Today I added a new dataset, again using Get Data > Web to retrieve my data.  After publishing my changes, I am unable to refresh the dataset from the web service, I receive an error stating that a gateway is required.  This is the new connection, it's syntax is similar but not identical:

let
    Source = Web.Page(Web.Contents("http://www.rssweather.com/wx/us/wa/cottage%20lake/wx.php")),

I removed the new dataset and republished, refresh works again as expected.  Scratching my head, I created 2 simple repro .pbix files to demonstrate the problem.  Here is a look at the dataset settings pages for both:

Have any of you overcome problems like these and willing to offer suggested approaches to avoid the gateway?

Anyone have a point to the features / limitations of Dataset.Settings.Gateway connection = Connect directly?

[v-qiuyu-msft · Accepted solution]

Hi @mow700,

You can see Note from here: 

If you are using the Web.Page function, you do need a gateway if you have republished the dataset or your report after November 18th, 2016.

In your scenario, you need to install the on-premise data gateway then add web data source use the same web URL as you specified in Power BI desktop.

Or you can install the on-premise data gateway personal mode. Let the dataset use this kind of gateway. 

Best Regards,
Qiuyun Yu