Forum Discussion

PraseelNarayan's avatar
PraseelNarayan
New Member
4 years ago
Solved

Scheduled refresh is disabled

Hi , I'm getting data from a Webpage which loads fine on Power Bi Desktop. But when report is published to Power Bi Online, I cannot refresh the dataset.  I get the subjected error message. This W...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    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

Burningsuit's avatar
Burningsuit
Resident Rockstar
4 years ago

Hi PraseelNarayan 

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

PraseelNarayan's avatar
PraseelNarayan
New Member
4 years ago

Thanks Burningsuit , I will give this a shot and update later today