Forum Discussion
Report Builder Reports performance issue in Power Bi Service
We have report builder reports (paginated reports) published in Power Bi Service.
The performance is not good when it is accessed from Service especially selection criteria with casacading filters.
it works fine in desktop and On-prem report server (~30 Secs vs ~1 minute in power Bi service )
Is there any way we can check whats happening in power Bi service ? (logs, etc...)
Is there any performance option tuning from power Bi service end for paginated reports?
The queries takes only 9 secs (to fetch all records ) in the database (Oracle) . But it takes almost 1 minute from power Bi service.
From on-prem report server , its takes 20-25 secs.
We also tried using power Bi dataset as source which didnt help much.
Note : Power Bi Desktop is not an option as we have specific layout requirements which is not possible with Power Bi.
2 Replies
v-lionel-msftCommunity Support
Hi venkatnitt84 ,
Please refer to this case:
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
rpatkarPower BI Team
Have you tried https://docs.microsoft.com/en-us/power-bi/service-premium-capacity-manage#power-bi-premium-capacity-metrics-app? It will indicate tme take for data fetch, processing and rendering the report. If that does not help then you'll need to engage with Support. Thanks.