Forum Discussion

motoray's avatar
motoray
Icon for Advocate V rankAdvocate V
1 year ago

Refreshes from SQL over the Gateway taking longer and longer

We have a Power BI Premium Capacity (yep, still thanks to our EA) and I've noticed that over the past year, data refreshes for Power BI reports published to the service are taking an average of 200 s...
Need Help
v-menakakota's avatar
v-menakakota
Icon for Community Support rankCommunity Support
1 year ago

Hi motoray ,

You saw some relief after rolling back to May 2024, so version differences matter. Try testing with the latest gateway version on a non-production node there may be performance improvements or fixes.

 Even small delays between the gateway and your SQL Server can add up across 300+ reports.It’s worth checking for increased network latency or DNS resolution issues

If I misunderstand your needs or you still have problems on it, please feel free to let us know.   

Best Regards, 
Menaka.
Community Support Team  

motoray's avatar
motoray
Icon for Advocate V rankAdvocate V
1 year ago

We've just installed the May 21, 2025 version recently, but I don't expect that to fix anything. Due to other issues with failed refreshes and open tickets with Microsoft, we've been on the bleeding edge of Gateways since October and refresh times continue to get longer, not shorter.

  • v-menakakota's avatar
    v-menakakota
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi motoray 

    Thanks for the update I completely understand how frustrating this must be, especially after staying up to date with the latest gateway versions and still seeing performance get worse. Since the issue seems persistent across all reports and gateway versions, it may be worth looking into other potential bottlenecks.

    • Reviewing gateway diagnostics logs can help identify whether delays are happening during authentication, query execution, or data transfer.
    • Running the same queries directly against SQL Server, outside of Power BI, may reveal issues like blocking, slow execution plans, or other performance constraints.
    • Monitoring for network latency or DNS resolution issues between the gateway and SQL Server could help, as even small delays can add up significantly across many refreshes.

      If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
      Thank you for reaching out to us on the Microsoft Fabric Community Forum.
       
      Best Regards, 
      Menaka. 
      Community Support Team.
       
    • v-menakakota's avatar
      v-menakakota
      Icon for Community Support rankCommunity Support
      1 year ago

      Hi  motoray ,

      May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster. 

       

      Thank you. 

      • motoray's avatar
        motoray
        Icon for Advocate V rankAdvocate V
        1 year ago

        We're currently testing, but still having issues.  If we find a solution, I'll come back here and let everyone know. And if someone's suggestion solves the problem, I'll likewise come back and mark that suggestion as the answer. As of right now the problem is still there.