Forum Discussion

MoorsTech's avatar
MoorsTech
Icon for Advocate I rankAdvocate I
4 years ago

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 ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

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.