cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mauropasi Regular Visitor
Regular Visitor

scheduling different refresh times for different tables in an sql on-premise database

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?

2 REPLIES 2
mauropasi Regular Visitor
Regular Visitor

Re: scheduling different refresh times for different tables in an sql on-premise database

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.

ankitpatira Super Contributor
Super Contributor

Re: scheduling different refresh times for different tables in an sql on-premise database

@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.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)