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

RDL file size limit for Report Server

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

 

HDLA_0-1620342876546.png

 

 

 

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

 

HDLA_2-1620343129370.png

 

 

5 REPLIES 5
HDLA
Frequent Visitor

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

AbhiSSRS
Solution Supplier
Solution Supplier

Hi!

 

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

 

AbhiSSRS_0-1620716642817.png

 

HDLA
Frequent Visitor

Hello, follow instruction and it is not working for me

 

Updated web.config and restart service

HDLA_1-1620755426858.png

 

Upload 4mb xml file get this error

HDLA_0-1620755406791.png

 

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
Solution Supplier
Solution Supplier

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

 

 

HDLA
Frequent Visitor

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

what will be the step to troubleshoot?

HDLA_0-1620452689456.png

HDLA_1-1620454516176.png

 

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!