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.
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
Yes everything is working on my local machine.
For some reason, Power BI still thinks I need a gateway, I saw some other posts where people tried to disassociate a report with an on-prem gateway and also ran into issues.
It seems impossible to deactivate the gateway in the Power BI Service, even though I am only using online data sources at this time.
I should not need a gateway now...
For some web connectors gateway is required, Try to configure it properly and see if it is working or not.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂