Forum Discussion
Post PartisanHow often can we refresh a model when storage mode is mixed
Since its direct query, the model is also scheduled for refresh every 15 mins.Thes two things are unrelated. The concept of a refresh does not apply to a Direct Query data source. Refreshes will only affect the Import Mode data sources in your dataset.
It is not clear what you are trying to accomplish. Please elaborate.
Post Partisanlbendlin , my understanding is the same that my direct query will be directing taking the data from the query. However, in one of a direct query model, I could see there was a schedule refresh was applied there which was for every 15mins. I just wanted to check if this schedule refresh is really required for a direct query model. Secondly when I connect my excel as a second data source to this model, I can see only 2 options in schedule refresh, one is daily and the other is weekly.
Since I am unable to do any testing on a production model, I just wanted to Validate that data refresh will not be affected when 2nd data source is added to the model.
- lbendlin
Super User
I just wanted to check if this schedule refresh is really required for a direct query modelNo. Be aware that there is another functionality - APR - that may add to the confusion.
when I connect my excel as a second data source to this modelThat needs more details. Is that Excel file on a Sharepoint, or did you import it into the workspace?