By default, Power BI uses full refresh of tables. Which means that before any refresh, all data from previous load are deleted.

But you can also use the incremental refresh. To keep some of original data (or all) and change (or add) just new values. Obviously, this load can be much quicker when you don´t load everything again and again.

How to do it? You have to do three steps:pří

  • Create parameters
  • Setup filter
  • Setup the incremental refresh itself

Parameters

Create two parameters. Their names have to be RangeStart and RangeEnd. The datatype has to be Date Time (the same asi the date column in table).

Default value of RangeStart has to be lower then oldest date in table and RangeEnd has to be higher then potential newest date.

Filter setup

Set the custom filter on the date column, defining, that data has to be between parameters. 

Incremental refresh

Close the Power Query editor. Click on three dots at table and select Incremental refresh. 

Switch on the incremental refresh and fill in the two fields.

In the first one define the length of period, that has to be kept. Everything older will be delete. In second parameter define the length of period, which has to be refreshed / added.

The incremental refresh works after upload to Powerbi.com.

Leave a Reply

Your email address will not be published.

*

clear formPost comment