Forum Discussion
Paginated report with multi value filter data load service error
Hi Lancy_vini
The available documentation for Paginated Reports provides guidance on the overall workflow, including report authoring, deployment, data connectivity and rendering scenarios.
To help visualize the process, please refer to the official documentation below :
Create and Use the Paginated Report Visual - Power BI | Microsoft Learn
What Are Paginated Reports in Power Bi? - Power BI | Microsoft Learn
I am trying to understand the architectural flow of powerbi paginated report with direct query model and multivalue parameter for my better understanding
Hi Lancy_vini
The architectural flow in this scenario is:
Paginated Report → Semantic Model (DirectQuery) → DAX Query Engine → DirectQuery Translation → Amazon Redshift.
It highlights how multi-value parameters are passed into the semantic model, converted into DAX, and then translated into SQL for Redshift. The caution note at the bottom reminds that large intermediate datasets may still be processed before filters are fully applied, depending on query folding and model complexity.
Hi v-aatheeque if the data is filtered at redshift/ sql level then why my report is failing with 1M error .if I remove the multivalue filter the same report works fine . With parameters my results are just 2000 rows .but I get error saying that data exceeded 1million rows .
Hi Lancy_vini
The 1M row limit is likely being hit during intermediate query processing, not from the final result returned to the report.
When the multi-value parameter is applied, Power BI may generate a different DAX query internally and process a larger intermediate dataset before the filter is fully pushed down to Redshift. Because of this even if the final output is only 2000 rows, the backend execution may still exceed the 1M row threshold internally.
Without the multi-value parameter, the query path remains simpler, which is why the report works successfully.
Hi Lancy_vini
We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.