Forum Discussion
Excel Pivot Table Filters being checked
Hi TDouglass ,
Sounds like you want incremental refresh. Please kindly refer to
Incremental refresh for data sources based on Power Query or Azure Data Lake provides the following advantages:
Faster refreshes - Only data that has changed gets refreshed. For example, you might refresh only the past five days of a historical dataset.
Increased reliability - With smaller refreshes, you don't need to maintain connections to volatile source systems for as long, reducing the risk of connection issues.
Reduced resource consumption - Refreshing only a subset of your total data leads to more efficient use of computing resources and decreases the environmental footprint.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Stephen, The source of our data is an analysis services cube that is rebuilt every night. We don't build the data model via Power Query. Not sure if that changes your reply or not.