Forum Discussion
Gateway for Web data source?
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
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:
- 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.