topic Re: Deadlock on report server database when deploying Power BI report in Report Server

Deadlock on report server database when deploying Power BI report

Martin51 — Fri, 09 Jul 2021 15:11:58 GMT

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

Re: Deadlock on report server database when deploying Power BI report

d_gosbell — Sun, 11 Jul 2021 23:41:06 GMT

Your best approach here would be to raise an official support ticket with Microsoft. The powershell module uses the supported REST api under the covers so I do not believe that would be the issue. But this will possibly require a hotfix or changes to the database and both of those things would require the assistance of a support engineer.