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.
82 Comments
- grant_weaverNew MemberYes please!
- vinneyk1New MemberFor 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.
- firstredpepper
Advocate II
This would be super useful. - jhouckFrequent VisitorYes, 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!!!
- mauro_medeirosNew MemberThis is a serious problem. We have to manage a lot of connections that are not used in online refresh.
- michiel_rozema1New MemberI 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!
- sqlarchitect1New MemberWe 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.
- Nicole2020New MemberI too need to be able to exclude certain, static, tables from the refreshing.
- dcresp1New MemberI 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.
- Diodoardo_lucaNew MemberIs very important!
Recent ideas
Add "Collapse all / Expand all" to the Queries pane in Power Query Editor
Hi Fabric Community, I suggest adding a "..." menu beside Queries(n])with Collapse all and Expand all. Current state: With many queries, every group and Helper Queries folder is expanded. My 8...DataVitalizer23 hours agoSuper UserNew12Views0likes0CommentsAdd Automated Pre-Upgrade Compatibility Assessment for Fabric Spark Runtimes
Microsoft Fabric should provide an automated compatibility assessment before a workspace, Environment, notebook, or Spark Job Definition is upgraded to a newer Fabric Runtime. Spark runtime upgra...mourakshit1 day agoNew MemberNew6Views0likes0CommentsSupport Creator-Independent Managed Identity and Ownership Transfer for Fabric Operations Agents
Microsoft Fabric Operations Agents should support an enterprise identity and ownership model that is independent of the individual user who originally created the agent. Today, an Operations Agent r...mourakshit1 day agoNew MemberNew11Views0likes0Comments