Microsoft today announced a new feature in Power BI service that allows dataset owners to control the frequency of the scheduled cache refresh of their DirectQuery and live connection datasets. Whenever you set up DirectQuery or live connection against a data source, the Power BI will make live queries when users interact with report visuals. To improve quick loading of the data, Power BI keeps a cache for dashboard visuals created against the data source. The cache will be updated regularly over a period of time. With today’s announcement, Microsoft is giving dataset owners full control over how often this scheduled cache refresh happens.
You can now select refresh frequency ranging from 15 minutes to weekly. Microsoft is also setting the scheduled cache refresh cadence of all existing DirectQuery and live connection datasets to be one hour.
Learn more about it here.