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
Enhance Power BI with Advanced AI-Powered DAX Optimization and Performance Monitoring
Description I would like to suggest introducing advanced AI-powered DAX optimization and performance monitoring capabilities directly into Power BI. As Power BI solutions become more complex, de...ADABOINA_SAIRAM8 hours agoRegular VisitorNew7Views0likes0CommentsexecuteDaxQueries-like API call with effectiveUserName on SSO-enabled model with Service Principal
Please provide a way for a service principal to execute DAX - with an effective user name - against an SSO-enabled directlake semantic model and get per-user results that respect lakehouse OneLake Se...sean_cochran9 hours agoResolver INew16Views1like1CommentEnable Analyze in Excel Without Build Permissions on Power BI Semantic Models
Description: Currently, Power BI requires users to have Build permissions on a semantic model to use the Analyze in Excel feature. However, this permission also grants users the ability to create new...Anonymous11 hours agoNot applicableNew3.8KViews26likes2Comments