cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

Status: New
Comments
v-robertq-msft
Community Support

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