Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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

 

 

7 REPLIES 7
varadharajan
New Member

have any solution pls

varadharajan
New Member

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

Anonymous
Not applicable

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

AbhiSSRS
Solution Sage
Solution Sage

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

 

Anonymous
Not applicable

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

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 applicable

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.