Paginated Report Hangs on ‘View Report’ with Large Parameter Lists in Power BI Service

[HemanthPrakash]

I have a paginated report deployed to the Power BI Service that uses DirectQuery to retrieve data from a SQL database.

The report has 4 parameters, and 2 of the parameters have large value lists of about 3000 items each.

When I click View Report, the report starts running, but the View Report button becomes greyed out, and the report start throwing error.

Has anyone experienced this with large parameter lists in paginated reports? Are there any best practices or workarounds to improve performance in this scenario?

[v-lgarikapat · Accepted solution]

Hi @HemanthPrakash 

Thanks for reaching out to the Microsoft fabric community forum.

@HemanthPrakash 

It would be greatly helpful if you could please provide more details regarding the error. This will make it easier for us to troubleshoot and offer an appropriate solution.

We sincerely appreciate your engagement and thank you for being an active member of the community.

Best regards,
Lakshmi.

[v-lgarikapat]

Hi @HemanthPrakash ,

We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

We appreciate your engagement and thank you for being an active part of the community.

Best Regards,
Lakshmi.

[v-lgarikapat]

Hi @HemanthPrakash ,

We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

We appreciate your engagement and thank you for being an active part of the community.

Best Regards,
Lakshmi.

[v-lgarikapat]

Hi @HemanthPrakash ,

Hi @HemanthPrakash ,

We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

We appreciate your engagement and thank you for being an active part of the community.

Best Regards,
Lakshmi.