getting error when loading report

mhesabi89 — Tue, 25 Jul 2023 13:42:01 GMT

I often encounter an error while loading reports on Power BI Report Server. Although it sometimes resolves on its own, I have noticed that the following URL generates an error 500: /powerbi/api/explore/reports/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxx/modelsAndExploration. I also added related logs in below.

I'm using version May 2023, I had same problem with previous versions but I could fix it by modifiying some scripts on report server's database, unfortunalty now I can't find that solution in internet.

Can you please provide guidance on how to fix this error?

2023-07-25 15:16:41.2911|INFO|59|Received request GET /api/explore/reports/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxx/modelsAndExploration| RequestID = e56c0d34-6bf1-00e6-2982-d429a746d07d ClientSessionID = b2655a34-c9d1-8ac7-eac4-1174b1846876
2023-07-25 15:16:41.3067|ERROR|59|Unhandled error in the Web API|GET https://domain.com/powerbi/api/explore/reports/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxx/modelsAndExploration?preferReadOnlySession=true - Response Unknown| RequestID = e56c0d34-6bf1-00e6-2982-d429a746d07d ClientSessionID = b2655a34-c9d1-8ac7-eac4-1174b1846876 System.IO.IOException: There is no data in the database for @CatalogItemId=e6e41eba-a41c-425d-a7d0-33a53a22e578;@ContentType=PowerBIReportDefinition
at Microsoft.ReportingServices.CatalogAccess.Streams.VarbinaryReadableStream.InitializeDatabaseAccess()
at Microsoft.ReportingServices.CatalogAccess.Streams.VarbinaryReadableStreamFactory.CreateExtendedContentReadableStream(Guid catalogItemId, ExtendedContentType contentType)
at Microsoft.ReportingServices.CatalogAccess.CatalogItemAccessor.GetExtendedContentReadable(Guid catalogItemId, ExtendedContentType contentType)
at Microsoft.PowerBI.ReportServer.WebApi.Catalog.CatalogService.<GetPowerBIReportDefinitionStream>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.ReportServer.WebApi.Catalog.CatalogService.<GetPbixComponentsAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.ReportServer.WebApi.PbiApi.PbiApiController.<GetModelsAndExplorationAsync>d__22.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Threading.Tasks.TaskHelpersExtensions.<CastToObject>d__1`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__6.MoveNext()

Re: getting error when loading report

d_gosbell — Wed, 26 Jul 2023 01:58:14 GMT

This seems to be the key part of the error message:

There is no data in the database for @CatalogItemId=e6e41eba-a41c-425d-a7d0-33a53a22e578;@ContentType=PowerBIReportDefinition

If you've been editing the database you should probably try rolling back those changes as they could be causing this.

But I think you will need to contact support and raise a support ticket with them.

Re: getting error when loading report

cbernardo — Wed, 10 Apr 2024 18:14:29 GMT

Hey! Did you ever get this issue figured out?
User just reported issues with some folders not loading and I'm seeing the same error on the logs.
"There is no data in the database for @CatalogItemId=<id_redacted>;@ContentType=PowerBIReportDefinition"

topic Re: getting error when loading report in Report Server

getting error when loading report

Re: getting error when loading report

Re: getting error when loading report