Forum Discussion
Helper IIWhy schedule refresh button is showing with direct query mode?
With DirectQuery you will see the Scheduled cache refresh option, which is used for refreshing the cached data of the visuals.
You can set that to refresh up until every 15 minutes if you want.
As the info says, you can also refresh a specific tile any time.Did I answer your question? Then please mark my post as a solution!
My blog: nickyvv.comAh, that mixed mode explains why you don't see the option, that's perfectly fine. The gateway datasource does need to be there, you don't have to set a refresh schedule for DirectQuery.
So you should be fine I think.
Did I answer your question? Then please mark my post as a solution!
My blog: nickyvv.com
Most Valuable ProfessionalWith DirectQuery you will see the Scheduled cache refresh option, which is used for refreshing the cached data of the visuals.
You can set that to refresh up until every 15 minutes if you want.
As the info says, you can also refresh a specific tile any time.
Did I answer your question? Then please mark my post as a solution!
My blog: nickyvv.com
Helper III'm not seeing Schedule Cache Refresh option availabe on Dataset setting.
Does it need any gate way to run?
Let me clear my model is actually based on mix mode. Facts are using direct query from azure sql and some hard code tables i ahve created. Is that the actuall reason? i can go with Direct query for all tables.
- nickyvv
Ah, that mixed mode explains why you don't see the option, that's perfectly fine. The gateway datasource does need to be there, you don't have to set a refresh schedule for DirectQuery.
So you should be fine I think.
Did I answer your question? Then please mark my post as a solution!
My blog: nickyvv.com