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
Power BI Dynamic Subscription Capacity Consumption and Recipient Processing
Issue: The concern is that the dynamic subscription workload can consume a significant amount of capacity when generating and distributing personalized report outputs. This creates a scalability conc...vivek123448 hours agoMicrosoft EmployeeNew4Views0likes0CommentsSchedule pipeline as Service Principal
It would be beneficial to be able to specify an anonymous sp or user account while creating a schedule to run a pipeline directly in the Fabric GUI. This is currently only possible via the rest api a...Juriaan8091125510 hours agoNew MemberNew4Views0likes0CommentsImprove Databricks Native SQL Development Experience in Power BI
As organizations increasingly adopt Databricks as their primary data platform, Power BI remains a preferred tool for semantic modeling, visualization, executive reporting, and self-service analytics....Applsfan11 hours agoNew MemberNew5Views0likes0CommentsFabric Workspace Operator Role for Pipeline Monitoring and Rerun Operations
Many organizations have dedicated production support and operations teams responsible for monitoring Microsoft Fabric pipelines and responding to failures. Currently, the available workspace roles ar...cmukul00711 hours agoRegular VisitorNew67Views4likes1CommentPower BI Admin to Disable the New Ribbon Preview & Control Rep Toolbar Visibility at Tenant Level
Allow Power BI Administrators to Disable the New Ribbon Preview and Control Report Toolbar Visibility at Tenant Level It takes too much real estate and by default users with low maturity leaves it a...icassiem11 hours agoPost ProdigyNew34Views5likes1Comment