Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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?
@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.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
9 | |
7 | |
6 |