Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
TomTomTom
Helper II
Helper II

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 2
Greg_Deckler
Super User
Super User

@TomTomTom You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Yes - Pro Premium ...

 

Would you be thinking this is a bug in the MS data centre or something then ?!

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors