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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Heena_9980400
Helper IV
Helper IV

Assistance Required for Resolving URL Character Limit Issue in Paginated Report

Hi Team,

Heena_9980400_1-1738481511642.png

 

I hope this email finds you well. I am reaching out for assistance in resolving an issue I am encountering with a paginated report.

The report is designed such that, after selecting multiple parameters, clicking on the Reject column record redirects to a child report.

However, an error is displayed:

"The report parameter list exceeds the limit of 2040 characters. Please reduce the selected values for Zone 1, 2, 3 WO# dropdown."

To provide more context, I have attached the expression currently being used to achieve the functionality:

=IIF(LEN(Globals!ReportServerUrl + "?%2fBRS+Singapore%2fPA+Reports%2fTIJ4%2fSGP_Falcon%2fProduction+Reports%2fReject_Pen_summery_yield&rs:Command=Render&rc:Toolbar=False&StartDate= " & Parameters!parstartdate.Value & "&EndDate= " & Parameters!parenddate.Value & "&ShiftList= " & Join(Parameters!parshiftinclude.Value, ",") & "&moduleky= " & Fields!MODULE_DIM_KY.Value & "&pruntype= " & Join(Parameters!paruntype.Value, ",") & "&Zone1Wo= " & Join(Parameters!Zone1Wo.Value, "&Zone1Wo=")) <= 2083, "javascript&colon;void(window.open('" + Globals!ReportServerUrl + "?%2fBRS+Singapore%2fPA+Reports%2fTIJ4%2fSGP_Falcon%2fProduction+Reports%2fReject_Pen_summery_yield&rs:Command=Render&rc:Toolbar=False&StartDate= " & Parameters!parstartdate.Value & "&EndDate= " & Parameters!parenddate.Value & "&ShiftList= " & Join(Parameters!parshiftinclude.Value, ",") & "&moduleky= " & Fields!MODULE_DIM_KY.Value & "&pruntype= " & Join(Parameters!paruntype.Value, ",") & "&Zone1Wo= " & Join(Parameters!Zone1Wo.Value, "&Zone1Wo=") + "'))", "")  

The main concern is ensuring that even after selecting "Select All" for the parameters, the report does not exceed the character limit and continues to function without errors.

If this issue cannot be resolved due to known limitations, I would appreciate any suggestions for alternative approaches. Specifically:

  1. Is there a way to handle this within the report itself, avoiding the need to jump to a child report?
  2. After publishing to Power BI Service, can any modifications be made to overcome this limitation?
  3. Are there any other workarounds to ensure that selecting "Select All" does not lead to an error?

Looking forward to your valuable suggestions and assistance!

 

Thank you.

Best regards,
Heena Kousar

4 REPLIES 4
v-jtian-msft
Community Support
Community Support

Hi,rohit1991 and tharunkumarRTK ,thanks for your concern about this issue.

Your answers are excellent!
And I would like to share some additional solutions below.


Hello,@Heena_9980400 .

I hope my suggestions below will help you


There is a known issue with the url parameter length exceeding the limit.
Could you try adding a new column for your data source to pre-process the data at the data source. I noticed that you have multiple fields that need to be filtered.
You could try combining URL combinations of certain parameters into one specific type. For each type, you tag it with the corresponding index.
like this.

parshiftincludeB+parenddateC =newcolumnValuesBC
parshiftincludeN+parenddateM =newcolumnValuesNM
...


Map each different URL combination to new parameter values of shorter length. (use the values of “newcolumnValues”)
Report query data using these actual shorter values of the parameters for paginated reports.
This might shorten the length of the final URL parameter.

vjtianmsft_0-1738733963693.png


I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

hi @v-jtian-msft ,

 

Thanks for your reply!

 

you mean to say adding these details in expressions or in the backend.

 

if you could please help me understanding this for better implemtation. that would be very helpful thank you.

rohit1991
Super User
Super User

Hi @Heena_9980400 ,

Your report exceeds the 2040-character limit due to long parameter lists.

Solutions:

  1. Reduce URL Length:

    • Pass IDs instead of names
    • Use abbreviations
    • Limit selections instead of "Select All"
  2. Use Drillthrough Reports:

    • Avoid long GET URLs
    • Pass parameters through report actions
  3. Store Selections in SQL:

    • Save selected values in a temporary table
    • Pass a Session ID instead of long lists
  4. Optimize "Select All":

    • Pass a default value ("All") instead of listing all selections

"The goal is to turn data into information, and information into insight." – Carly Fiorina

Need Power BI help? Connect on LinkedIn.

tharunkumarRTK
Super User
Super User

@Heena_9980400 

If I am not mistaken you are drilling through from one paginated reort to the other using URL parameters and all the filter values are within the URL. You are hitting the max character limit due to which you are facing an error.

 

I have a couple of suggestions, 

1. Instead of using URL paramters and constructing a Child report URL, cannot you use the "Go to report" and pass the filter values? You can follow the instructions explained here 

https://www.youtube.com/watch?v=k7pZzwgXW-g

2. Incase if you are passing the actual field values within the URL parameter cannot you try reducing the number of charaterts by passing their IDs. IDs will have less number characters than the actual values.

 

Need a Power BI Consultation? Hire me on Upwork

 

 

 

Connect on LinkedIn

 

 

 








Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!


PBI_SuperUser_Rank@2x.png

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.