Hi, I'm getting failures multiple times a day across varying datasets, error messages are a variation on: Failure details: Web.Contents failed to get contents from 'https://COMPANY.sharepoint.co...
Regarding your second link, the issue persists across datasets whether there are merged queries and expanded columns or not.
One of the datasets in question consists only of a SQL query (that is used in other datasets which refresh without problems), and two excel tables.
Therefore I don't think query optimisation is the answer as there is nothing to optimise.
I do not see anything resembling the errors I'm getting in the first link either.