Exclude a table from refresh in Power BI Service
Ability to exclude a table from Data Refresh (scheduled, manual, API, etc.) in the Service.
In PBI Desktop, we have an option "Include in report refresh" we can disable for a table. But it won't affect PBI Service.
Louis dorn commented
This definitely seems like a bug.
Is very important!
David Cresp commented
I have just realised that this is the issue that is meaning that I can't refresh in Power BI Service. It took me a while to find this idea and it seems crazy that you can turn refresh of in PBI Desktop but that this has no effect in Power BI Service. There are lots of cases that not all the data needs to be refreshed. Please MS make it so that this works in Desktop and PBI Sericve. It does not make any sence for this setting to not work in both locations.
NICOLE FALK SMITH commented
I too need to be able to exclude certain, static, tables from the refreshing.
We need the ability to have individual tables removed from any refresh process in the Power BI Service. There are situations where there are large, static tables (2.5+ million rows) that don't need to be refreshed by the service. If and when there is any need to refresh such, we could refresh in the Power BI Desktop and publish the dataset.
Mauro Medeiros commented
This is a serious problem. We have to manage a lot of connections that are not used in online refresh.
I agree with Eoin that this is a bug, or at least an 'undocumented feature'. IMHO, the 'include in report refresh' feature in Power BI Desktop doesn't make sense when it doesn't work in Power BI service.
Please please please fix this!
This is a bug not a feature. Please fix.
James Houck commented
Yes, the "Exclude from Refresh" should definitely persist to the service once the report is published from the desktop. In the interest of speeding up my data refreshes within the Power BI client, I have many dimension tables that remain static and I don't need to requery them. On second thought, having a scheduled for EACH table would be even better!!!
Vinney K commented
For context, I arrived at this post through a thread originating from this post attempting to create a workaround for the lack of incremental load in datasources: http://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
This would have been an acceptable temporary workaround were it not for the issue of excluding from report refresh having no effect in the Power BI service.
This would be super useful.
Grant Weaver commented