Deadlock on report server database when deploying Power BI report
Good afternoon, We are getting some random failures while deploying Power BI .pbix reports to our report server. Error: An error has occurred [Microsoft.PowerShell.Commands.WriteErrorException: System.Exception: Failed to create catalog item: The remote server returned an error: (500) Internal Server Error. ---> System.Net.WebException: The remote server returned an error: (500) Internal Server Error. After investigation we can see that this type of errors are caused by deadlocks on the report server database. Object name: ReportServer.dbo.DataModelDataSource Index name: PK_DataModelDataSource Object name: ReportServer.dbo.DataModelDataSource Index name: IX_ItemId_ModelConnectionName We deploy the reports via a release pipeline and make use of the ReportingServicesTools PowerShell module. Our report server version is: Version 1.11.7815.26414 (May 2021) Best regards, Martin B