getting error when loading report
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()
Status Code 500 PowerBI Libs List Folder
Hi, This is the problem that occurs to us: I access a PowerBI report (.pbix) with the following URL: https://server.domain/reports/powerbi/FolderRoot/SubfolderOne/Report1 The report loads correctly. Then, without leaving the page, I remove the report name from the URL, leaving only the full URL up to the folder where the report is. https://server.domain/reports/powerbi/FolderRoot/SubfolderOne/ An error has occured Please try again later or contact technical support. Please provide these details if you contact them. undefined: Request Identifier: c4458468-3c79-f832-1d04-080c16c183a7 Status code: 500 Time: Wed May 03 2023 12:36:37 GMT+0200 (Central European Summer Time) Service version: /powerbi/libs I appreciate the help Thanks, Jose Luis
