Forum Discussion
Post PartisanHow often can we refresh a model when storage mode is mixed
I have a power bi model which uses direct query. Since its direct query, the model is also scheduled for refresh every 15 mins. Now on this model we are trying to add excel as a data source, so the storage mode changes to mixed. In this case schedule refresh is either for daily( 8 times a day) or weekly unlike how it was in the direct query model.
There are 2 things I am trying to observe/note:
1. I want to make sure that if the model is mixed and refresh every 15 mins is disabled then it should not affect anything to my existing model.
2. I want the excel source also to refresh as often as the direct query, if not what is the maximum nos of time we can refresh data connected to excel source.
Also if I try page refresh every 30 monutes will that help and will that affect anything on my existing report.
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.
4 Replies
- lbendlin
Super User
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.
Aviveklbendlin , 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
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?
