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
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.

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

        Haven't really made any progress on this still. Testing continues. Long refresh times persist.