Cancellation occurred when sending or receiving all files. Serious problems

[masplin]

I have 4 models on schedule refresh. Last one updated successfully at 10am but since then all models are immediately showing this error. i have treid restarting the gateway, which shows online, but no joy. I have not touched the models, but they wil lhave picked up new data during the day.  I have tried to refresh the pbix file and cannot get them to  refesh as just churning the data without finishing.  These would normally complete in about 20 mins.  I'm concenred some bad data has got into the model, but dont know if this would cause this error message (which pops upin 5 seconds)

Any clues appreciated as al lthe company reporting and CRM is now dead in the water

Mike

Power BI

Last refresh failed: Tue Jul 17 2018 19:23:20 GMT+0100 (GMT Summer Time)
Cancellation occurred when sending or receiving a request.Hide details

Cluster URI:	WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID:	4e859633-842b-0517-1568-617ea8849bf0
Request ID:	819d9cb4-5c35-61f3-085b-9cc2f093aba3
Time:	2018-07-17 18:23:20Z

[naidoode]

I had a similar issue. It occurred when a bad date got into the dataset. Run the query against your DB and find and fix any bad dates. I simply just put in a "where AuditDate >= DATEADD(year,-1,GETDATE())" clause to only select valid dates and it worked like a charm.

[masplin]

Sadly I dont think that is the issue.  i opened the pbix file and refreshed each table one by one and all worked fine. i then republished and was fine. Then the next scheduled refresh failed again?