Forum Discussion

Alexander24's avatar
Alexander24
Helper II
8 years ago

Incremental refresh - Process ADD

Hi there

 

Can anyone advise how we would achieve the same output as process add in Power BI's Incremental Refresh.

 

In Tabular, you can set a partition to only add new rows, so not even updating historic rows, i.e adding new rows added to the table in the last 5-10mins.

 

Thanks

Alexander

Need Help
Tutorial Requests

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Alexander24,

     

    In fact, incremental refresh feature not works as you thought, it need to manually setting parameters as refresh range.

    Please take a look at following link to know more about this feature.

    Incremental refresh in Power BI Premium

     

    Regards,

    Xiaoxin Sheng

    • Alexander24's avatar
      Alexander24
      Helper II
      8 years ago

      Can we use an M function to automatically set the ranges??

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        HI Alexander24,

         

        According to official document, it seems like incremental feature not support auto config. You need to manually setting these range before use it.
        In addition, you can also submit an idea to idea forum to help us improve this feature.

         

        Regards,

        Xiaoxin Sheng