Forum Discussion

Advocate I

6 years ago

Solved

Gateway for Web data source?

Can anyone tell me why I would need an on-premises data gateway to refresh data in the Service if I only have web data sources?

gbrunnerbi
6 years ago
OK I have found the problem.

This query produces the issues:
"https://www.sozialministerium.at/Informationen-zum-Coronavirus/Neuartiges-Coronavirus-(2019-nCov).html"

When I use:
= Web.BrowserContents("https://www.sozialministerium.at/Informationen-zum-Coronavirus/Neuartiges-Coronavirus-(2019-nCov).html")

It requires the gateway and I cannot refresh it unless I have it installed.

As soon as I change it to:
=Web.Contents("https://www.sozialministerium.at/Informationen-zum-Coronavirus/Neuartiges-Coronavirus-(2019-nCov).html")

It allows me to refresh from the service and the gateway is turned off - I do not need a gateway now

Very strange! But it appears that Web.BrowserContents functions like Web.Page

Community Champion

6 years ago

Sometimes web connectors will fail to refresh the data set, You can follow this for resolving the issue https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power-bi/

If it is not working, as per the Microsoft documentation, you have to install the gateway https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios#refresh-using-web-connector-doesnt-work-properly

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂