scheduled dataset refresh failing while manual, api and xmla endpoint work

[vasko]

Scheduled dataset refresh failing, started 4 days ago
on both Premium and Embedded capacity, on all datasets, on all sources

Failure details: The last refresh attempt failed because of an internal service error.

This is usually a transient issue. If you try again later and still see this message, contact support.

The scheduled refresh is cancelled because a new refresh is detected on the same database.

Where should we look for the issue?

Manual, api and xmla endpoint refresh work, also direcrt query via same Gateway Cluster work

[v-robertq-msft]

Hi,

I think you can go to the scheduled refresh setting to check if you have configured the scheduled refresh time as the peak period. (huge interactive and background operations at the same time)

If so, you can try to schedule the scheduled refresh time to midnight or early morning and check if it can work.

Please follow this link:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh#scheduled-refresh

Best Regards,

Community Support Team _Robert Qin