Forum Discussion
Incremental Data Refresh
Hi I have a SQL data source with 50M rows. I need to refresh my desktop monthly, but don't need all the data refreshed - just the new data added that month. Is is possible to simply add the ...
Have a read of this blog. I think it's the best we can do on the current feature set.
While it will work ok, it will make your PBI Desktop model bigger than it needs to be
http://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/