Dynamic query URL breaks on refresh

[alexsimpson]

I have a saved table on a web service that provides a dynamic query via a url. I managed to get data, put the web page in and pull through the table and alter it in query editor. Everything was working perfectly until I refreshed the following dat and I get the error below:

 

Any help would be much appreciated. I have a horrible feeling I am going to have to rebuild the whole query editor around the data again!!

Many thanks in advance,

Alex

[Eric_Zhang]

---

@alexsimpson wrote:

I have a saved table on a web service that provides a dynamic query via a url. I managed to get data, put the web page in and pull through the table and alter it in query editor. Everything was working perfectly until I refreshed the following dat and I get the error below:

 

Any help would be much appreciated. I have a horrible feeling I am going to have to rebuild the whole query editor around the data again!!

Many thanks in advance,

Alex

---

@alexsimpson

It looks like that the web page used as source has been changed, have you ever check that source?

[alexsimpson]

Hi Eric,

The link works.

http://analytics.financialexpress.net/Table.aspx?SavedResultsID=C8E3EA8B-2E39-E611-B03F-D067E5E5C882...

It takes a little while to load though. Could it be that Power BI times out?

Thanks,

Alex