Forum Discussion
Power Bi report capacity issue
I have created a paginated report which is dynamically changes column header through a stored procedure.
Now the issue is When one user run the report with new parameters then it taking 17% of the capacity. With the cache memory when I reuse the parameters then it is taking only 0.4% of the capacity. I have removed the dynamically changing column header then ran with new parameters then it is takoing 4% of capacity.
The question is, how can I resolve this issue? because one user for one report it is taking 17% capacity then multiple users run the report at same time then whole capacity is gone.
Need some help to resolve this, Please share your solutions.
Thank you.
2 Replies
Paginated reports have an inherently high rendering cost. making them dynamic increases that cost even more. Does it really have to be dynamic or can you prerender multiple different versions?
Hi smilika ,
I would like to apologize for the belated reply.
You might consider taking advantage of Power BI's caching capabilities by preloading the report with a set of common parameters that users might select.
Additionally, if possible, you might consider simplifying the data model to reduce the complexity of the report. Remove any unnecessary calculated columns or tables that are not used in the report.
If capacity issues persist and are business critical, consider migrating to Power BI Premium for dedicated capacity.
For more you may refer to:Paginated reports capacity planning for Power BI Premium - Power BI | Microsoft Learn
Best Regards,
Yulia Yan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
