Scheduled refresh repeatedly fails, Azure DB using DirectQuery

[Anonymous]

The error is situational, usually it's working but sometimes the refresh fails several days in a row. 

It's set up with 'Basic' connect, or 'Windows' when edited. I cannot find similar problems or a guide. How to fix?

[v-yuezhe-msft]

@Anonymous,

Are you able to manually refresh the data un Power BI Service? Could you please post the full error message including request id and cluster URL here?

Regards,
Lydia

[Anonymous]

Yes, I can always refresh manually. 

Here is a couple of error message examples:

Klynge-URI:	WABI-NORTH-EUROPE-redirect.analysis.windows.net
Aktivitets-id:	733570c4-bd7e-481e-b630-4d7bb3a7c4eb
Anmodnings-id:	759a7795-c15e-47d0-826f-b3c9c1908b92
Klokkeslæt:	2018-12-04 02:00:20Z

Klynge-URI:	WABI-NORTH-EUROPE-redirect.analysis.windows.net
Aktivitets-id:	a7fea5bf-2096-4a77-ad7d-9ebc9ab17a31
Anmodnings-id:	60125740-1c6f-4d91-a06f-034721eada15
Klokkeslæt:	2018-12-10 02:01:41Z

[v-yuezhe-msft · Accepted solution]

@Anonymous,

Some similar issues have been reported internally. And the fix for the issue will be deployed by 12/15. Please check if schedule refresh works well after 12/15.

Regards,
Lydia