Forum Discussion
Need a workaround for Direct Query causing server to crash
We are running a dashboard which pulls data from an SQL database. We need the data to be live, or almost live (45 minute syncing would be fine). Currently we use Direct Query, which because of the am...
Have you already considered incremental refresh to greatly reduce the refresh time, so you could use import mode? If refresh takes >45 min, you could also consider using a hybrid table (if you have Premium or PPU).
Pat