Forum Discussion
Power BI Report Server cannot create the schedule refresh
When I try to create a schedule refresh, I get the message: Occurred an error, cannot find the item '/report'.
This is my service user svc_powerbi.
This is the roles that is associated to the service user:
After reading some documents and try some experiments I got the reason about the problem. I was using DirectQuery when I connect with the database, but you can only create a schedule report if you import all the schema or table or you can create a view on the database and import this table view to visualize on Power BI Desktop, and that allows you create a schedule report on the Power BI Report Server.
6 Replies
After reading some documents and try some experiments I got the reason about the problem. I was using DirectQuery when I connect with the database, but you can only create a schedule report if you import all the schema or table or you can create a view on the database and import this table view to visualize on Power BI Desktop, and that allows you create a schedule report on the Power BI Report Server.
Hi WandersonReis ,
I ran into the same issue. After changing the account from "Virtual Service Account" to "Domain account", the error disappeared. But I don't know the reason. Need to study more.
Reference:
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
Hi Icey Thanks for u answer.
I will try and then I post here the result.
Unfortunattely that doesn't solve my problem, I had already set this before:
But the error still happens
Hi WandersonReis ,
Sorry to reply late. I can't reproduce other situations that make it impossible to create a schedelued refresh.
Please check the log here:
C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFilesor
D:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFilesto find if there are some useful error message.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
Icey No problem, thanks for your help.
Here is some logs that was generated when I try to create a schedule report:
The log from RSPortal_2021_01_27_08_47_16 is:
2021-01-27 09:05:40.8629|INFO|118|Received request GET /api/v2.0/CatalogItems(Path='/faturamentoBI')| RequestID = s_7c5a9c90-f729-4d48-82d2-e4fd8b55bff3
2021-01-27 09:05:40.9471|INFO|102|Sending response. Response code IMPRENSA\svc_powerbi 200, Elapsed time 0:00:00,0874189| RequestID = s_7c5a9c90-f729-4d48-82d2-e4fd8b55bff3
2021-01-27 09:05:40.9627|INFO|118|Received request GET /api/v2.0/PowerBIReports(0d096ee5-2492-4d9b-a2dd-ed8c2c814dbd)/DataModelRoles| RequestID = s_ef399298-bce8-4812-8926-a272778bf345
2021-01-27 09:05:41.0943|INFO|98|Sending response. Response code IMPRENSA\svc_powerbi 200, Elapsed time 0:00:00,1329181| RequestID = s_ef399298-bce8-4812-8926-a272778bf345
2021-01-27 09:05:41.1321|INFO|118|Received request GET /api/v2.0/CatalogItems(Path='/faturamentoBI')| RequestID = s_bece8233-d9ea-466a-8673-18e24b3e6c2b
2021-01-27 09:05:41.2481|INFO|98|Sending response. Response code IMPRENSA\svc_powerbi 200, Elapsed time 0:00:00,1059586| RequestID = s_bece8233-d9ea-466a-8673-18e24b3e6c2b
2021-01-27 09:06:05.7180|INFO|118|Received request GET /api/v2.0/CatalogItems(Path='/faturamentoBI')| RequestID = s_aea7b358-a289-4495-be97-634ea355ef4e
2021-01-27 09:06:06.0032|INFO|96|Sending response. Response code IMPRENSA\svc_powerbi 200, Elapsed time 0:00:00,2929176| RequestID = s_aea7b358-a289-4495-be97-634ea355ef4e
2021-01-27 09:06:06.0032|INFO|118|Received request GET /api/v2.0/PowerBIReports(0d096ee5-2492-4d9b-a2dd-ed8c2c814dbd)/DataModelRoles| RequestID = s_80afd9df-fc26-4edf-ad43-87a2070fedb6
2021-01-27 09:06:06.1877|INFO|95|Sending response. Response code IMPRENSA\svc_powerbi 200, Elapsed time 0:00:00,1723376| RequestID = s_80afd9df-fc26-4edf-ad43-87a2070fedb6
2021-01-27 09:06:06.2723|INFO|118|Received request GET /api/v2.0/schedules| RequestID = s_1159b6e8-7955-4c41-849b-d8b7a3a55a8c
2021-01-27 09:06:06.6044|INFO|95|Sending response. Response code IMPRENSA\svc_powerbi 200, Elapsed time 0:00:00,3294876| RequestID = s_1159b6e8-7955-4c41-849b-d8b7a3a55a8c
2021-01-27 09:06:06.6044|INFO|118|Received request POST /api/v2.0/schedules/model.describe| RequestID = s_77f1e254-6466-4389-a162-35e67846ad19
2021-01-27 09:06:06.6044|INFO|95|Sending response. Response code IMPRENSA\svc_powerbi 200, Elapsed time 0:00:00,0034572| RequestID = s_77f1e254-6466-4389-a162-35e67846ad19
2021-01-27 09:06:47.4590|INFO|92|Received request POST /api/v2.0/CacheRefreshPlans| RequestID = s_6bdde5b3-09dd-48a7-8068-46181582ee34
2021-01-27 09:06:47.4958|INFO|111|Received request POST /api/v2.0/CacheRefreshPlans| RequestID = s_32f94457-d529-4a5a-bda6-1ee8c1ce8fb1
2021-01-27 09:07:51.0305|ERROR|111|OData exception occurred: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Não é possível encontrar o item '/faturamentoBI'. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: Não é possível encontrar o item '/faturamentoBI'.
at Microsoft.ReportingServices.Library.ReportingService2010Impl.CreateCacheRefreshPlan(String ItemPath, String Description, String EventType, String MatchData, ParameterValue[] Parameters, String& CacheRefreshPlanID)
at Microsoft.ReportingServices.WebServer.ReportingService2010.CreateCacheRefreshPlan(String ItemPath, String Description, String EventType, String MatchData, ParameterValue[] Parameters, String& CacheRefreshPlanID)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2010.ReportingService2010.CreateCacheRefreshPlan(String ItemPath, String Description, String EventType, String MatchData, ParameterValue[] Parameters)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.<>c__DisplayClass136_0.<CreateCacheRefreshPlan>b__0()
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.CreateCacheRefreshPlan(String itemPath, String description, String eventType, String matchData, ParameterValue[] parameters)
at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapRS2010Proxy.<>c__DisplayClass19_0.<CreateCacheRefreshPlan>b__0()
at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapAuthenticationHelper.ExecuteWithWindowsAuth[TReturn](SoapHttpClientProtocol soapClient, IPrincipal userPrincipal, Func`1 func)
at Microsoft.ReportingServices.Portal.Repositories.SubscriptionService.CreateCacheRefreshPlan(IPrincipal userPrincipal, CacheRefreshPlan cacherefreshPlan)
at Microsoft.ReportingServices.Portal.ODataWebApi.V2.Controllers.CacheRefreshPlansController.AddEntity(CacheRefreshPlan entity)
at Microsoft.ReportingServices.Portal.ODataWebApi.Controllers.Reflection.EntitySetReflectionODataController`1.Post(ODataPath oDataPath, T value)
at lambda_method(Closure , Object , Object[] )
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.<GetExecutor>b__2(Object instance, Object[] methodParameters)
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)
--- 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.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().| RequestID = s_32f94457-d529-4a5a-bda6-1ee8c1ce8fb1
2021-01-27 09:07:51.0305|ERROR|92|OData exception occurred: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Não é possível encontrar o item '/faturamentoBI'. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: Não é possível encontrar o item '/faturamentoBI'.
at Microsoft.ReportingServices.Library.ReportingService2010Impl.CreateCacheRefreshPlan(String ItemPath, String Description, String EventType, String MatchData, ParameterValue[] Parameters, String& CacheRefreshPlanID)
at Microsoft.ReportingServices.WebServer.ReportingService2010.CreateCacheRefreshPlan(String ItemPath, String Description, String EventType, String MatchData, ParameterValue[] Parameters, String& CacheRefreshPlanID)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2010.ReportingService2010.CreateCacheRefreshPlan(String ItemPath, String Description, String EventType, String MatchData, ParameterValue[] Parameters)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.<>c__DisplayClass136_0.<CreateCacheRefreshPlan>b__0()
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.CreateCacheRefreshPlan(String itemPath, String description, String eventType, String matchData, ParameterValue[] parameters)
at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapRS2010Proxy.<>c__DisplayClass19_0.<CreateCacheRefreshPlan>b__0()
at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapAuthenticationHelper.ExecuteWithWindowsAuth[TReturn](SoapHttpClientProtocol soapClient, IPrincipal userPrincipal, Func`1 func)
at Microsoft.ReportingServices.Portal.Repositories.SubscriptionService.CreateCacheRefreshPlan(IPrincipal userPrincipal, CacheRefreshPlan cacherefreshPlan)
at Microsoft.ReportingServices.Portal.ODataWebApi.V2.Controllers.CacheRefreshPlansController.AddEntity(CacheRefreshPlan entity)
at Microsoft.ReportingServices.Portal.ODataWebApi.Controllers.Reflection.EntitySetReflectionODataController`1.Post(ODataPath oDataPath, T value)
at lambda_method(Closure , Object , Object[] )
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.<GetExecutor>b__2(Object instance, Object[] methodParameters)
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)
--- 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.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().| RequestID = s_6bdde5b3-09dd-48a7-8068-46181582ee34
2021-01-27 09:07:51.0305|INFO|12|Sending response. Response code IMPRENSA\svc_powerbi 500, Elapsed time 0:01:03,5335644| RequestID = s_32f94457-d529-4a5a-bda6-1ee8c1ce8fb1
2021-01-27 09:07:51.0305|INFO|45|Sending response. Response code IMPRENSA\svc_powerbi 500, Elapsed time 0:01:03,5761933| RequestID = s_6bdde5b3-09dd-48a7-8068-46181582ee34The log from RSManagement_2021_01_27_00_41_42 is:
2021-01-27 09:06:58.3642|ERROR|6|Unhandled error in the Web API. Exception: System.Net.Http.HttpRequestException: Error while copying content to a stream. ---> System.IO.IOException ---> System.Net.HttpListenerException: The I/O operation has been aborted because of either a thread exit or an application request
at System.Net.HttpResponseStream.EndWrite(IAsyncResult asyncResult)
at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult)
--- End of inner exception stack trace ---
at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult)
at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
--- End of inner exception stack trace ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Owin.HttpMessageHandlerAdapter.<SendResponseContentAsync>d__33.MoveNext()| RequestID = s_5ed456e1-86c8-49cb-ad1f-1f506cad3d76
2021-01-27 09:06:58.3642|INFO|6|IMPRENSA\svc_powerbi ::1: GET /api/v1.0/ManagementState - 0:00:00.0533782
Connection dropped| RequestID = s_5ed456e1-86c8-49cb-ad1f-1f506cad3d76 System.Threading.Tasks.TaskCanceledException: A task was canceled.
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Owin.HttpMessageHandlerAdapter.<SendResponseContentAsync>d__33.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Owin.HttpMessageHandlerAdapter.<InvokeCore>d__20.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.BIServer.Management.WebHost.RequestLoggingMiddleWare.<Invoke>d__2.MoveNext()
