Forum Discussion

MEFOX's avatar
MEFOX
Icon for Helper III rankHelper III
4 years ago

Long running direct query report

I have a report written using direct query. It takes about 3 minutes to refresh when a user opens the report. Is there any value in setting up a scheduled houly refresh of the dataset stored in the w...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Scheduling will not help at all. However Microsoft have just announced automatic aggregation options that allow you to cache frequent queries, and to potentially improve the user experience.

 

You will be better off studying the queries that cause the slowness, and improving the performance of your data source.