Formula Referencing Cells that are Refreshed by Data Query

Whenever the source of a data query (in this case pulling data from an API query) is temporarily broken (might happen once every day or once a week) the table that it brings into the sheet reduces from the usual several columns and rows to just 2 cells (the heading of the query and then just a 0 value as I've made it return that upon error).

Looking for ideas and methods on either:

1. upon data query error to create a table the same as what would be expected (rows and columns) should the query be successful and fill it with either last known values or 0s
2. in excel formula somehow don't lose the cell reference when the data query fails and reduces to the 2 cell table (the formula ends up with #ref at the moment when the data query fails as the table loses most of its columns and rows)

Thanks,
Stuart.

Desktop apps for Office 365 - (full excel application on Windows 10 although when you click about it says 365).

It fails because the website in question may either be under maintenance or something happens where the query (runs every 15 seconds or every minute depending on which query) returns null but the next one might work.

The query is like this:

= try Json.Document(Web.Contents("http......")) otherwise 0

because if I don't put otherwise 0 then when it fails it displays a message box by default saying there was an issue or something and then it stops macros running in the background and everything stops. So I made it try it first then put 0 in if it failed which stopped the spreadsheet stopping but means that the table reduces to just a 0 and all my formulas based on it will then lose reference.

Thanks for your response.

See attached workbook - powerqueries inside.

Is it possible to do a try function but if it fails it does nothing and just leaves previous values or doesn't post anything at all??