Forum Discussion
Append query to dataset and remove outdated data
I want to have a dataset in my Power BI file with 2 years worth of transactional data. This creates over 600M rows. Instead of refreshing the entire dataset each time I run the report, is there a...
Hi Anonymous ,
If you have a Premium license, you can use incremental refresh in the service. Here is the document for your reference.
https://docs.microsoft.com/en-us/power-bi/service-dataflows-incremental-refresh
As for the desktop, I don't think that there is anyway to actually do an incremental load on a Desktop model.