Forum Discussion

panipat1990's avatar
panipat1990
Helper III
8 years ago

Incremental refresh data

Dear Community,

 

As i read article that incremental refresh data feature is coming in power bi MAY Version  Desktop..I tried many times refresh incremental data..

I have data For one year and i want to only new data enter..one year data save in power bi...How to do..

 

If someone implement this feature kindly send me  step by step..Because i used many times .but i didnot reach it..

 

Please let me know if some oneone achieved this..

Need Help

29 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    8 years ago

    Hey,

     

    here are some links that will get you started to use incremental refresh:

    You have to be aware, that Incremental Refresh will be configured using PBI Desktop, but will shows its magic just inside the Power BI Service with a dedicated Premium Capacity.

     

    This means, that a Power BI Premium capacity is needed to utilize the benefite of incremental data refresh, at least for the moment, because in this post https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/ indicates that there is a possibility that incremental refresh will also come to Power BI Pro users.

     

    And please be aware that, the incremental refresh is still in Preview.

     

    Hopefully this gets you started

     

    Regards

    Tom 

    • panipat1990's avatar
      panipat1990
      Helper III
      8 years ago

      Dear Tom,

       

      i read and  i saw this vedio..but i am not implemented incremental refresh data.

      Firstly I go to Option and settings then go to option and then check in Incremental refresh data.....

      Second i create two parameter like RangeStart and RangeEnd..then i Set custom filter to My date field..then i Publish to this table...

      then i went to table and right click on it and click on  incremental Refresh data..then i set 5 years refresh data and 10 days last rows ..

      but t is not working kindly tell me...and Guide what step i missing

      • panipat1990's avatar
        panipat1990
        Helper III
        8 years ago

        i have a data last month .And i Want to Save as historical and pick up only incremental data

        Data is

         

        Order_DateSale
        01-12-201278
        02-12-201279
        03-12-201280
        04-12-201281
        05-12-201282
        06-12-201283
        07-12-201284
        08-12-201285
        09-12-201286
        10-12-201287
        11-12-201288
        12-12-201289
        13-12-201290
        14-12-201291
        15-12-201292
        16-12-201293
        17-12-201294
        18-12-201295
        19-12-201296
        20-12-201297
        21-12-201298
        22-12-201299
        23-12-2012100
        24-12-2012101
        25-12-2012102
        26-12-2012103
        27-12-2012104
        28-12-2012105
        29-12-2012106
        30-12-2012107
        31-12-2012108
        01-01-2013109
        01-02-201379

         

        i want to save histroical data from 31/12/2013 and 01-01-2013 or 01-02-2013 is updated by incremently refresh

        kindly tell me step by step for taking this data which i given..it's very very  urgent..kindly help me