Forum Discussion

TomTomTom's avatar
TomTomTom
Helper II
3 years ago

Overnight Refresh No Longer Working

I have a PowerBI report that has been refreshing nicely overnight for several months... but has suddenly stopped. The refresh anonymously accesses a website and then returns data from it. I've tried to recredential the anonymous connection, but it doesn't seem to work.

 

Any ideas?

 

The M-code that queries the web-page is like this.

 

Web.Contents(
     "https://www.nhs.uk/",
     [
     RelativePath = "services/independent-provider/healthshare-ltd/X93452/ratings-and-reviews",
     Query = [currentpage= Text.From(Page)]
     ])

 

(The currentpage query just loops over all page numbers that return data.)

2 Replies