Incremental data load in PowerPivot through Power Query
We work with very large databases. Every time we update the information, it reloads all the data in the Power Pivot through Power Query, which takes a long time.
Undoubtedly we can make separate queries with the history and have the results added by DAX, but this forces us to duplicate all the metrics in DAX and parameterize everything.
Our request is whether there could be any way to update the data incrementally???? it would be fantastic.
PD.- Now we are using and we recommend our clients to use PowerUpdate that allows to program the update of the files.