cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mow700 Regular Visitor
Regular Visitor

Trouble avoiding gateway installations for scheduled refreshes

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:

 

snip_20170921115824.png

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Trouble avoiding gateway installations for scheduled refreshes

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.

 

q3.PNGq2.PNG

 

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

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
mow700 Regular Visitor
Regular Visitor

Trouble avoiding gateway installations for scheduled refreshes

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:

 

snip_20170921115824.png

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?

Moderator v-qiuyu-msft
Moderator

Re: Trouble avoiding gateway installations for scheduled refreshes

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.

 

q3.PNGq2.PNG

 

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

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.