Moving away from DirectQuery to scheduled refreshes (data source is a database)

Hi,

I have fully real-time PowerBI reports in operation using DirectQuery mode and querying direct to my Amazon Redshift database.

This is great, except it can be a bit slow compared with import modes!

I'd love for a mixture of the two options.

Ideally: Users could open a report and manually hit 'refresh', refresh the data (which would then remain static) and browse around the static data as per normal import mode without having to query the DB.

Alternatively: Slow down the whole process and just do scheduled refreshes and users would be able to navigate (fast) on a slight delay.

My questions are:

• Is #1 option possible? How would I set this up?
• If not, what is the best way to set up #2 and what would the smallest refresh time be?

For reference - I currently create the reports in PowerBI Desktop -> Publish them to PowerBI Service and then distribute them as Apps.

Thanks for your time.