Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
Hi Team,
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: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:
Looking forward to your valuable suggestions and assistance!
Thank you.
Best regards,
Heena Kousar
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.
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.
Hi @Heena_9980400 ,
Your report exceeds the 2040-character limit due to long parameter lists.
Reduce URL Length:
Use Drillthrough Reports:
Store Selections in SQL:
Optimize "Select All":
"The goal is to turn data into information, and information into insight." – Carly Fiorina
Need Power BI help? Connect on LinkedIn.
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
|
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.