Forum Discussion

Usustudent's avatar
Usustudent
Regular Visitor
7 months ago
Solved

Power BI Service Refresh Suddenly Slow / Timing Out on Pro, Desktop Fast

  Hi all, I’m seeing a strange refresh issue on Power BI Pro with a single on-prem gateway. Setup: Same dataset and tables, no model changes SQL Server data source Gateway diagnostics pass (36/...
Need Help
  • Usustudent's avatar
    Usustudent
    7 months ago

    Hi Anjan,

     

    Thank you for checking in. The issue resolved itself after about two days, and all my reports are now refreshing as expected. No support ticket was raised.

rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
7 months ago

Hii Usustudent 

 

This usually happens due to gateway resource constraints in Power BI Service, not a dataset issue. Desktop refresh runs locally with more memory and less parallelism, while Service refresh uses the on-prem gateway, runs tables in parallel, and is more memory-restricted. The errors you’re seeing (spooling, timeouts, disk usage) indicate the gateway is under memory or disk pressure, causing heavy disk spooling and long retries. Common fixes are increasing gateway RAM, ensuring fast disk and sufficient free space for temp/spool folders, reducing parallel load, and scheduling refresh during off-peak SQL hours.

Usustudent's avatar
Usustudent
Regular Visitor
7 months ago

Increased memory and disk space. Still the same issue

 

Is this causing the problem:

WARNING: Name resolution of analysis.windows.net failed ComputerName : analysis.windows.net RemoteAddress : InterfaceAlias : SourceAddress : PingSucceeded : False