Forum Discussion
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?
OK I have found the problem.
This query produces the issues:
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
11 Replies
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 🙂Thank you for your answer. I had one Web.Page function in my M code, now removed it.
I used an on-prem data gateway, now changed my sources to only web (without any web.page functions) and now the gateway is still on somehow, I cannot turn it off and at every refresh it is telling me this:
Refresh failed due to gateway configuration issues.This dataset requires a properly configured gateway in order to refresh.- Web { url : "https://www.sozialministerium.at/Informationen-zum-Coronavirus/Neuartiges-Coronavirus-(2019-nCov).html" }
- Web { url : "https://info.gesundheitsministerium.at/data/Bundesland.js" }
- Web { url : "https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_global.csv" }
- Web { url : "https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_recovered_global.csv" }
Please try again later or contact support. If you contact support, please provide these details.Is it working on your local machine? If you are getting this error, you have to add those sources to the gateway.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂Here is my latest blog - Dynamic Page Navigation Based on User Login
