Forum Discussion
Refresh timeouts - No load on Gateway or SQL DB
Hello Everyone, we have recently migrated our SQL and Enterprise Gateway servers and are experiencing strange and intermittent timeout problems with Power BI service refreshes of datasets. My main ...
does the timeout error message wax on about "transient issues" and ask you to "try again later" ?
In my experience each dataset refresh will only take 2GB of memory on average.
Are you confident that your SQL server can handle all the spool requests?
Also for stress testing you need to issue refresh requests to different datasets. If you ask for the same dataset to be refreshed over and over these requests will be ignored (especially while a refresh is in progress). And Power BI Service might try to outsmart you with its cache management.