cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
DBAEMAIL Frequent Visitor
Frequent Visitor

I can't publish to Power BI Report Server

Hello,

I am trying to publish a 1.8GB report, I have already set it up to accept files up to 2000MB.

When I start publishing, it starts to work normally, as I displayed the message below:

 

 https://cdn1.imggmi.com/uploads/2019/9/20/5d467105fe7be3316a255beace063820-full.jp

 

But minutes later this screen disappears without displaying any messages.

 

I go to the directory: C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles, to see the logs.

 

2019-09-20 11:42:01.9040|INFO|140|Received request GET /api/v2.0/ServiceState| RequestID = s_87b3d83b-b208-4709-8a89-554fc321009f 
2019-09-20 11:42:01.9197|INFO|140|Sending response. Response code  200, Elapsed time 0:00:00.0072859| RequestID = s_87b3d83b-b208-4709-8a89-554fc321009f 
2019-09-20 11:42:02.2996|INFO|64|Received request GET /api/v2.0/CatalogItems%28Path%3D%27/%27%29| RequestID = s_b1b4f446-281f-491a-ab30-dba6180bd175 
2019-09-20 11:42:02.3046|INFO|64|Sending response. Response code TBACORP\ADMINISTRATOR 200, Elapsed time 0:00:00.0049231| RequestID = s_b1b4f446-281f-491a-ab30-dba6180bd175 
2019-09-20 11:42:02.3696|INFO|178|Received request GET /api/v2.0/catalogitems%28862c296d-1df7-42ba-9016-5dd3846fd7c1%29/Model.Folder/catalogitems/| RequestID = s_96d4f930-cbb5-4ac8-894d-94ff5f04e5d6 
2019-09-20 11:42:02.4206|INFO|147|Sending response. Response code TBACORP\ADMINISTRATOR 200, Elapsed time 0:00:00.0510175| RequestID = s_96d4f930-cbb5-4ac8-894d-94ff5f04e5d6 
2019-09-20 11:42:03.8917|INFO|178|Received request GET /api/v2.0/CatalogItems%28Path%3D%27/Relat%C3%B3rio%20Autoinspe%C3%A7%C3%A3o%20CJF%202019%20-%20Subsecretarias_NOVO%27%29| RequestID = s_4d8ab1ae-6ec6-42b5-9e72-43b83e864a57 
2019-09-20 11:42:03.8917|INFO|178|Sending response. Response code TBACORP\ADMINISTRATOR 404, Elapsed time 0:00:00.002911| RequestID = s_4d8ab1ae-6ec6-42b5-9e72-43b83e864a57 
2019-09-20 11:42:22.1690|INFO|69|Received request GET /api/v2.0/System/Properties| RequestID = s_c62d2ce5-fcad-4035-af44-c11abe95b4a5 
2019-09-20 11:42:22.1690|INFO|69|Sending response. Response code TBACORP\ADMINISTRATOR 200, Elapsed time 0:00:00.0026766| RequestID = s_c62d2ce5-fcad-4035-af44-c11abe95b4a5 
2019-09-20 11:42:22.1690|INFO|83|Received request GET /api/v2.0/me| RequestID = s_be3e8dee-e1ea-4c66-9905-ba1f7b8d64f1 
2019-09-20 11:42:22.2010|INFO|83|Sending response. Response code TBACORP\ADMINISTRATOR 200, Elapsed time 0:00:00.0245354| RequestID = s_be3e8dee-e1ea-4c66-9905-ba1f7b8d64f1 
2019-09-20 11:42:25.3109|INFO|69|Received request POST /api/v2.0/powerbireports%28Path%3D%27/Relat%C3%B3rio%20Autoinspe%C3%A7%C3%A3o%20CJF%202019%20-%20Subsecretarias_NOVO%27%29/Model.Upload| RequestID = s_0638dbd2-e8b1-4527-a41f-93abeb8c5810 
2019-09-20 11:45:48.9776|ERROR|281|OData exception occurred: System.ObjectDisposedException: Safe handle has been closed
   at System.Runtime.InteropServices.SafeHandle.DangerousAddRef(Boolean& success)
   at System.StubHelpers.StubHelpers.SafeHandleAddRef(SafeHandle pHandle, Boolean& success)
   at Microsoft.Win32.Win32Native.GetTokenInformation(SafeAccessTokenHandle TokenHandle, UInt32 TokenInformationClass, SafeLocalAllocHandle TokenInformation, UInt32 TokenInformationLength, UInt32& ReturnLength)
   at System.Security.Principal.WindowsIdentity.GetTokenInformation(SafeAccessTokenHandle tokenHandle, TokenInformationClass tokenInformationClass)
   at System.Security.Principal.WindowsIdentity.get_User()
   at System.Security.Principal.WindowsIdentity.GetName()
   at System.Security.Principal.WindowsIdentity.get_Name()
   at Microsoft.ReportingServices.Portal.Services.Extensions.IdentityExtensions.ToUserContext(IIdentity identity)
   at Microsoft.ReportingServices.Portal.Services.ServicesUtil.CreateRsService(IPrincipal principal)
   at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.UploadPowerBIReport(IPrincipal userPrincipal, PowerBIReport pbiReport)
   at Microsoft.ReportingServices.Portal.ODataWebApi.V2.Controllers.PowerBIReportsController.<UploadStream>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Threading.Tasks.TaskHelpersExtensions.<CastToObject>d__3`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext().| RequestID = s_0638dbd2-e8b1-4527-a41f-93abeb8c5810 
2019-09-20 11:45:48.9776|INFO|8|Connection dropped. TBACORP\ADMINISTRATOR fe80::5dc9:db06:70fc:4fb3%12: POST /api/v2.0/powerbireports%28Path%3D%27/Relat%C3%B3rio%20Autoinspe%C3%A7%C3%A3o%20CJF%202019%20-%20Sub_Session_NEW%27%29/Model.Upload, Elapsed time 0:03:23.6518983| RequestID = s_0638dbd2-e8b1-4527-a41f-93abeb8c5810 

 

The above message states that my connection has been dropped.

 

2019-09-20 11:42:04.1483|INFO|61|Handling event with data: TimeEntered: 9/20/2019 2:42:00 PM, Type: Event, SessionId: 21afe489-9a57-485f-9429-9b73ed1d066e, EventType: DataModelRefresh
2019-09-20 11:42:04.1483|INFO|61|Processing Data Model Refresh: SessionId: 21afe489-9a57-485f-9429-9b73ed1d066e, Status: Starting Data Refresh.
2019-09-20 11:42:04.1483|INFO|61|Processing Data Model Refresh: SessionId: 21afe489-9a57-485f-9429-9b73ed1d066e, Status: Starting Retrieving PBIX AsDatabaseInfo.
2019-09-20 11:42:04.1743|INFO|61|Processing Data Model Refresh: SessionId: 21afe489-9a57-485f-9429-9b73ed1d066e, Status: Starting Verifying all the data sources are embedded.
2019-09-20 11:42:04.1773|INFO|61|Processing Data Model Refresh: SessionId: 21afe489-9a57-485f-9429-9b73ed1d066e, Status: Starting Verifying connection strings are valid.
2019-09-20 11:42:04.1773|INFO|61|Processing Data Model Refresh: SessionId: 21afe489-9a57-485f-9429-9b73ed1d066e, Status: Starting Streaming model to Analysis Server.
2019-09-20 11:42:04.3413|INFO|61|Processing Data Model Refresh: SessionId: 21afe489-9a57-485f-9429-9b73ed1d066e, Status: Starting Refreshing the model.
2019-09-20 11:42:10.1858|INFO|61|Processing Data Model Refresh: SessionId: 21afe489-9a57-485f-9429-9b73ed1d066e, Status: Starting Removing credentials from the model.
2019-09-20 11:42:10.3108|INFO|61|Processing Data Model Refresh: SessionId: 21afe489-9a57-485f-9429-9b73ed1d066e, Status: Starting Saving model to the catalog.
2019-09-20 11:43:14.6458|INFO|131|Received request POST /api/reportpropertiesfromlocalfiles| RequestID = s_0638dbd2-e8b1-4527-a41f-93abeb8c5810 
2019-09-20 11:44:04.2374|INFO|254|Handling event with data: TimeEntered: 9/20/2019 2:44:00 PM, Type: Event, SessionId: cb1db159-de3b-4dd2-a751-1bf700f44d1b, EventType: DataModelRefresh
2019-09-20 11:44:04.2374|INFO|254|Processing Data Model Refresh: SessionId: cb1db159-de3b-4dd2-a751-1bf700f44d1b, Status: Starting Data Refresh.
2019-09-20 11:44:04.2374|INFO|254|Processing Data Model Refresh: SessionId: cb1db159-de3b-4dd2-a751-1bf700f44d1b, Status: Starting Retrieving PBIX AsDatabaseInfo.
2019-09-20 11:44:04.2530|INFO|254|Processing Data Model Refresh: SessionId: cb1db159-de3b-4dd2-a751-1bf700f44d1b, Status: Starting Verifying all the data sources are embedded.
2019-09-20 11:44:04.2530|INFO|254|Processing Data Model Refresh: SessionId: cb1db159-de3b-4dd2-a751-1bf700f44d1b, Status: Starting Verifying connection strings are valid.
2019-09-20 11:44:04.2686|INFO|254|Processing Data Model Refresh: SessionId: cb1db159-de3b-4dd2-a751-1bf700f44d1b, Status: Starting Streaming model to Analysis Server.
2019-09-20 11:44:04.4249|INFO|254|Processing Data Model Refresh: SessionId: cb1db159-de3b-4dd2-a751-1bf700f44d1b, Status: Starting Refreshing the model.
2019-09-20 11:44:10.0366|INFO|254|Processing Data Model Refresh: SessionId: cb1db159-de3b-4dd2-a751-1bf700f44d1b, Status: Starting Removing credentials from the model.
2019-09-20 11:44:10.1502|INFO|254|Processing Data Model Refresh: SessionId: cb1db159-de3b-4dd2-a751-1bf700f44d1b, Status: Starting Saving model to the catalog.
2019-09-20 11:45:48.4264|INFO|254|Sending response. Response code TBACORP\ADMINISTRATOR 200, Elapsed time 0:02:33.7603943| RequestID = s_0638dbd2-e8b1-4527-a41f-93abeb8c5810 
2019-09-20 11:46:04.3184|INFO|337|Handling event with data: TimeEntered: 9/20/2019 2:46:00 PM, Type: Event, SessionId: 76f92c70-20c0-446c-a0a7-41caa110ee1e, EventType: DataModelRefresh
2019-09-20 11:46:04.3184|INFO|337|Processing Data Model Refresh: SessionId: 76f92c70-20c0-446c-a0a7-41caa110ee1e, Status: Starting Data Refresh.
2019-09-20 11:46:04.3184|INFO|337|Processing Data Model Refresh: SessionId: 76f92c70-20c0-446c-a0a7-41caa110ee1e, Status: Starting Retrieving PBIX AsDatabaseInfo.
2019-09-20 11:46:04.3340|INFO|337|Processing Data Model Refresh: SessionId: 76f92c70-20c0-446c-a0a7-41caa110ee1e, Status: Starting Verifying all the data sources are embedded.
2019-09-20 11:46:04.3340|INFO|337|Processing Data Model Refresh: SessionId: 76f92c70-20c0-446c-a0a7-41caa110ee1e, Status: Starting Verifying connection strings are valid.
2019-09-20 11:46:04.3340|INFO|337|Processing Data Model Refresh: SessionId: 76f92c70-20c0-446c-a0a7-41caa110ee1e, Status: Starting Streaming model to Analysis Server.
2019-09-20 11:46:04.4798|INFO|337|Processing Data Model Refresh: SessionId: 76f92c70-20c0-446c-a0a7-41caa110ee1e, Status: Starting Refreshing the model.
2019-09-20 11:46:10.2386|INFO|337|Processing Data Model Refresh: SessionId: 76f92c70-20c0-446c-a0a7-41caa110ee1e, Status: Starting Removing credentials from the model.
2019-09-20 11:46:10.3636|INFO|337|Processing Data Model Refresh: SessionId: 76f92c70-20c0-446c-a0a7-41caa110ee1e, Status: Starting Saving model to the catalog.
2019-09-20 11:48:04.4036|INFO|51|Handling event with data: TimeEntered: 9/20/2019 2:48:00 PM, Type: Event, SessionId: 114c11d0-0798-4f0a-9941-fbdaa3033bf8, EventType: DataModelRefresh
2019-09-20 11:48:04.4036|INFO|51|Processing Data Model Refresh: SessionId: 114c11d0-0798-4f0a-9941-fbdaa3033bf8, Status: Starting Data Refresh.
2019-09-20 11:48:04.4036|INFO|51|Processing Data Model Refresh: SessionId: 114c11d0-0798-4f0a-9941-fbdaa3033bf8, Status: Starting Retrieving PBIX AsDatabaseInfo.
2019-09-20 11:48:04.4192|INFO|51|Processing Data Model Refresh: SessionId: 114c11d0-0798-4f0a-9941-fbdaa3033bf8, Status: Starting Verifying all the data sources are embedded.
2019-09-20 11:48:04.4348|INFO|51|Processing Data Model Refresh: SessionId: 114c11d0-0798-4f0a-9941-fbdaa3033bf8, Status: Starting Verifying connection strings are valid.
2019-09-20 11:48:04.4348|INFO|51|Processing Data Model Refresh: SessionId: 114c11d0-0798-4f0a-9941-fbdaa3033bf8, Status: Starting Streaming model to Analysis Server.
2019-09-20 11:48:04.5755|INFO|51|Processing Data Model Refresh: SessionId: 114c11d0-0798-4f0a-9941-fbdaa3033bf8, Status: Starting Refreshing the model.
2019-09-20 11:48:10.4517|INFO|51|Processing Data Model Refresh: SessionId: 114c11d0-0798-4f0a-9941-fbdaa3033bf8, Status: Starting Removing credentials from the model.
2019-09-20 11:48:10.5767|INFO|51|Processing Data Model Refresh: SessionId: 114c11d0-0798-4f0a-9941-fbdaa3033bf8, Status: Starting Saving model to the catalog.
2019-09-20 11:50:04.5052|INFO|261|Handling event with data: TimeEntered: 9/20/2019 2:50:00 PM, Type: Event, SessionId: a7a05fde-b287-4a19-8d95-2f60e2e64e1c, EventType: DataModelRefresh
2019-09-20 11:50:04.5052|INFO|261|Processing Data Model Refresh: SessionId: a7a05fde-b287-4a19-8d95-2f60e2e64e1c, Status: Starting Data Refresh.
2019-09-20 11:50:04.5052|INFO|261|Processing Data Model Refresh: SessionId: a7a05fde-b287-4a19-8d95-2f60e2e64e1c, Status: Starting Retrieving PBIX AsDatabaseInfo.
2019-09-20 11:50:04.5208|INFO|261|Processing Data Model Refresh: SessionId: a7a05fde-b287-4a19-8d95-2f60e2e64e1c, Status: Starting Verifying all the data sources are embedded.
2019-09-20 11:50:04.5208|INFO|261|Processing Data Model Refresh: SessionId: a7a05fde-b287-4a19-8d95-2f60e2e64e1c, Status: Starting Verifying connection strings are valid.
2019-09-20 11:50:04.5365|INFO|261|Processing Data Model Refresh: SessionId: a7a05fde-b287-4a19-8d95-2f60e2e64e1c, Status: Starting Streaming model to Analysis Server.
2019-09-20 11:50:04.6771|INFO|261|Processing Data Model Refresh: SessionId: a7a05fde-b287-4a19-8d95-2f60e2e64e1c, Status: Starting Refreshing the model.
2019-09-20 11:50:10.3112|INFO|261|Processing Data Model Refresh: SessionId: a7a05fde-b287-4a19-8d95-2f60e2e64e1c, Status: Starting Removing credentials from the model.
2019-09-20 11:50:10.4362|INFO|261|Processing Data Model Refresh: SessionId: a7a05fde-b287-4a19-8d95-2f60e2e64e1c, Status: Starting Saving model to the catalog.
2019-09-20 11:50:35.3475|INFO|294|Started clean up of embedded models
2019-09-20 11:50:35.3475|INFO|294|Finished clean up of 0 embedded models

 

A 500 MB report I can publish normally.

Can someone help me?

 

Thanks,

_Keny

1 REPLY 1
VacekMar Frequent Visitor
Frequent Visitor

Re: I can't publish to Power BI Report Server

Have you tried publishing using upload button on report server? This orks well for me. In my experience with larger files only other option is faster connection.

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 224 members 2,725 guests
Please welcome our newest community members: