Hi everybody. Does anybody know if it is possible to schedule different refresh times for different tables in an sql on-premise database?
I have a table that contains historical data that does not change often (if ever) so no need to refresh it as often as the tables that do change. Can I move those tables to a different source maybe and set different scheduled refreshes that way?
I am talking about very big tables which is why I don't want to waste resources in useless refreshes. Or is the gateway smart enough to understand that the data has not changed since and so there is nothing to refresh?
Perhaps it can be done with some checks in an advanced query so that the query doesn't actually fetch any more data even if the scheduler requests it.
If anybody has any experience with this I would like to hear your opinions.
@mauropasi In PowerBI desktop if you click Edit Queries -> In Query Editor right click your table -> Properties -> Uncheck 'Enable refresh of this query' -> Close & Apply -> Save, next time you hit refresh in power bi desktop it will not refresh that table. When you publish that report to PowerBI service and is manually refresh or schedule refresh it should do the same as PowerBI desktop.
However in my testing I've found PowerBI service is still refreshing all the tables. I have submitted a support ticket with Microsoft for these and I will let you know as soon as I get response.