RDL file size limit for Report Server

[Anonymous]

This is specific for PowerBI Report server

I have a RDL file size about 1.5 MB.

when review few columns from the table tablix to reduce the size.  I have no issue to deploy the report.

but once the file size over 1.5MB.

below error when trying to deploy

Severity Code Description Project File Line Suppression State
Error System.Web.Services.Protocols.SoapException: There was an exception running the extensions specified in the config file. ---> System.Web.HttpException: Maximum request length exceeded.
at System.Web.HttpRequest.GetEntireRawContent()
at System.Web.HttpRequest.get_InputStream()
at System.Web.Services.Protocols.SoapServerProtocol.Initialize()
--- End of inner exception stack trace ---
at System.Web.Services.Protocols.SoapServerProtocol.Initialize()
at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing) 0

for older version Report server usually adding a config maxRequestLength will work

Any suggestion for the latest version PowerBI report server

[varadharajan]

have any solution pls

[varadharajan]

if u got any solution for above mentioned issue ,yes meants can u share the solution pls

[Anonymous]

This is not resolve yet. 
Any suggestion about the error?

[AbhiSSRS]

Hi!

Please make the change only in web.config and check Like I have below length set up and it works well.

[Anonymous]

Hello, follow instruction and it is not working for me

Updated web.config and restart service

Upload 4mb xml file get this error

RSPortal_2021_05_11_10_47_37

see below error :

2021-05-11 10:49:18.1154|INFO|10|Received request PUT /api/v2.0/catalogitems(a974dde6-a84b-4794-8f0c-4ab21c7285ba)| RequestID = s_c9ed1c27-b711-462f-9ef9-3c9c83bb472f
2021-05-11 10:49:29.9746|ERROR|10|OData exception occurred: Microsoft.SqlServer.ReportingServices2010.RSConnection2010+MissingEndpointException: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. ---> System.InvalidOperationException: Client found response content type of '', but expected 'text/xml'.
The request failed with an empty response.
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.SetItemDefinition(String ItemPath, Byte[] Definition, Property[] Properties)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SetItemDefinition(String itemPath, Byte[] definition, Property[] properties)
at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapAuthenticationHelper.ExecuteWithWindowsAuth[TReturn](SoapHttpClientProtocol soapClient, IPrincipal userPrincipal, Func`1 func)
at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.UpdateReport(IPrincipal userPrincipal, String origItemPath, Report item, Boolean renameOrMove, String[] delta)
at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.Update(IPrincipal userPrincipal, String origItemPath, CatalogItem catalogItem, String[] delta)
at Microsoft.ReportingServices.Portal.ODataWebApi.V2.Controllers.CatalogItemsController.PutEntity(String key, CatalogItem entity)
at Microsoft.ReportingServices.Portal.ODataWebApi.Controllers.Reflection.EntitySetReflectionODataController`1.Put(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_c9ed1c27-b711-462f-9ef9-3c9c83bb472f

[AbhiSSRS]

Please try to upload large files directly to ReportServer from portal. 

For deployment issue :

You may serach for Timeout property in config on powerBireport server and set that. Its same as legacy report server in web.config

<httpRuntime executionTimeout="9000" requestValidationMode="2.0" />

set it to below (the maxrequestlength is in KB and max value can be set to Max value of integer 2147483647

<httpRuntime executionTimeout="9000" maxRequestLength="100000" requestValidationMode="2.0" />

Apart from this you may set below to higher value in RSReportServer.config for reports that run longer :

<Add Key="DatabaseQueryTimeout" Value="300"/>

<MemoryThreshold>90</MemoryThreshold>

Please mark as solution if this helps!

Thanks!
Abhinav

[Anonymous]

Not working, seems there are some error and I got a dump file with error log

what will be the step to troubleshoot?