Jean-Pierre Riehl on 17 Aug 2017 15:02:16
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.
- Comments (51)
RE: Exclude a table from refresh in Power BI Service
This definitely seems like a bug.
RE: Exclude a table from refresh in Power BI Service
Is very important!
RE: Exclude a table from refresh in Power BI Service
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.
RE: Exclude a table from refresh in Power BI Service
I too need to be able to exclude certain, static, tables from the refreshing.
RE: Exclude a table from refresh in Power BI Service
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.
RE: Exclude a table from refresh in Power BI Service
This is a serious problem. We have to manage a lot of connections that are not used in online refresh.
RE: Exclude a table from refresh in Power BI Service
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!
RE: Exclude a table from refresh in Power BI Service
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!!!
RE: Exclude a table from refresh in Power BI Service
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.
RE: Exclude a table from refresh in Power BI Service
This would be super useful.