Report Builder Reports performance issue in Power Bi Service

[venkatnitt84]

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.

[rpatkar]

Have you tried https://docs.microsoft.com/en-us/power-bi/service-premium-capacity-manage#power-bi-premium-capacity-...? 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.

[v-lionel-msft]

Hi @venkatnitt84 ,

Please refer to this case:

Performance Issue in Service  

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.