Power BI Report Server - Scheduled refresh does not work

[alex202309]

Hi there,

We have a problem with PBIRS and its refresh schedule. All new assigned schedules don't work. In debug mode we see errors in RSPowerBI_*.log files:

|DEBUG|67|Exception during db accessSystem.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SubscriptionHistory_Subscriptions". The conflict occurred in database "ReportServer", table "dbo.Subscriptions", column 'SubscriptionID'.
The statement has been terminated.

Any ideas to resolve?

Thanks in advance.

[d_gosbell]

log a support ticket with Microsoft