topic Re: Performance Discrepancy Between Non-Prod and Prod Power BI Gateway Refreshes in Report Server

Performance Discrepancy Between Non-Prod and Prod Power BI Gateway Refreshes

Anonymous — Wed, 30 Jul 2025 06:11:48 GMT

Hello Microsoft Support,

We are experiencing a performance issue with Power BI dataset refreshes that appears to be related to our gateway configuration.

Issue Summary:

We have two Power BI gateways: Non-Prod and Prod, both located in the same region and configured with identical properties.
When refreshing the same Power BI report using the Non-Prod Gateway, the refresh completes quickly.
However, using the Prod Gateway, the refresh is significantly slower, despite no changes in the report, data source, or server configuration.

Request:

We would appreciate your assistance in identifying the root cause of this discrepancy. Specifically, we would like to understand if there are:

Any known issues or throttling affecting the Prod Gateway
Network latency or resource bottlenecks
Logs or diagnostics we can collect to assist in troubleshooting

Please let us know if you require additional information or logs from our side.

Thank you for your support.

Best regards,
Thalla, Shravan
Software Engineer

Re: Performance Discrepancy Between Non-Prod and Prod Power BI Gateway Refreshes

jaineshp — Wed, 30 Jul 2025 06:17:08 GMT

Hi Anonymous ,

Here are a few steps you can try to pinpoint the root cause:

Check Gateway Load – Confirm if the Prod gateway is handling more datasets or concurrent refreshes than Non-Prod.
Review Event Logs – Export and review gateway logs during refresh to identify bottlenecks (CPU, memory, errors).
Compare Data Source Latency – Even if source is same, verify if network or SQL response times differ for Prod.
Update Gateway Version – Ensure both gateways are on the same and latest version.
Run a Trace – Use Performance Monitor or Gateway Diagnostics Tool during refresh for deeper insight.
Capacity & Throttling – Check if the workspace is tied to a Premium capacity and if it's being throttled during Prod refresh.
Network Check – Run ping/traceroute from gateway machine to DB server to compare latency.

Hope this works!

Best Regards,
Jainesh Poojara | Power BI Developer

Re: Performance Discrepancy Between Non-Prod and Prod Power BI Gateway Refreshes

lbendlin — Thu, 31 Jul 2025 01:19:12 GMT

This here is a forum where users help users, time permitting. For Microsoft support - If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

Re: Performance Discrepancy Between Non-Prod and Prod Power BI Gateway Refreshes

Anonymous — Thu, 31 Jul 2025 04:54:48 GMT

Hi Anonymous ,
Thank you for reaching out to the Microsoft fabric community forum. I appreciate the steps you've already taken to isolate the issue.

As jaineshp mentioned, check the load and version on both gateways, review logs for issues, and use diagnostic tools to spot bottlenecks. Also, test network latency and confirm if Premium capacity limits could be affecting refresh performance.

To assist further, Microsoft provides guidance on monitoring and optimizing on-premises data gateway performance, which you can refer to here: https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-performance These resources can help you interpret the diagnostics and understand underlying issues.

As lbendlin correctly mentioned, this forum is helpful for general support, but for a deeper investigation involving gateway logs or performance issues, it's better to contact Microsoft Support directly by raising a support ticket.

Hope this helps. Please reach out for further assistance.

Thank you.

Re: Performance Discrepancy Between Non-Prod and Prod Power BI Gateway Refreshes

Anonymous — Mon, 04 Aug 2025 05:11:57 GMT

Hi Anonymous ,

I wanted to follow up on our previous suggestions. We would like to hear back from you to ensure we can assist you further.

Thank you.

Re: Performance Discrepancy Between Non-Prod and Prod Power BI Gateway Refreshes

Anonymous — Thu, 07 Aug 2025 04:31:40 GMT

Hi Anonymous ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

Re: Performance Discrepancy Between Non-Prod and Prod Power BI Gateway Refreshes

Anonymous — Sun, 10 Aug 2025 13:07:18 GMT

Hi Anonymous ,

We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.

Thank you.