Forum Discussion
Scheduled refresh is disabled
Hi PraseelNarayan ,
I have tested the method Burningsuit said, it does not work if you use Web.BrowerConnects()
And publish to service. Dataset can configure scheduled refresh after edit date source credentials.
if you have tried and success, please mark one post that you think is helpful for you. Anyone have the same problem as you will find the solution quickly.
Best Regards
Community Support Team _ chenwu zhu
Yes, using the standard web connector in Power BI/Power Query requires a Gateway to refresh the data when published to the cloud, even if the Web page does not require any authentication.
There is a possible work around.
In PowerQuery ("Transform data" when you connect to the Web Page in Power BI desktop) Change the "source" line, often the first line of the Power Query steps, from " = WebBrowserContents("**your URL **")" to " = WebContents("**your URL **")".
Microsoft's documentation states that:
Web.BrowserContents "Returns the HTML for the specified url, as viewed by a web browser."
whereas
Web.Contents "Returns the contents downloaded from url as binary"
So, depending on the web page you are using, you may see a difference, but in most cases this works fine.
Then publish your Report, and you should be able to schedule refreshing.
Hope this helps
Stuart
Hi Burningsuit ,
Unfortunately this did not work. I'm getting an error :
Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh.
There are no credentials needed here, so really not sure what my next steps should be?
As v-chenwuz-msft has said you can, of course install a Personal Gateway. However I think that all you need to do (if you've used WebContents, rather than WebBrowserContents) is to go to the Credentials part of the Dataset settings...
and there Click on "edit credentials" and there set the Authentication Method to "Anonymous"
That should allow you then to scredule Refreshing for the web-page in Service.
Hope this helps
Stuart