Forum Discussion

skootz's avatar
skootz
Frequent Visitor
6 years ago

Incremental refresh - power bi refresh automatically

Good morning all , I implemented an incremental refresh. https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/ I created 3 tables a "don'trefresh", a "refresh" and...
Need Help
skootz's avatar
skootz
Frequent Visitor
6 years ago

You send me a message about my issue ? 

 

Thanks

  • ImkeF's avatar
    ImkeF
    Community Champion
    6 years ago

    Hi skootz ,

    this is an old workaround during the days when didn't have incremental refresh with pro-licenses. 
    I wouldn't recommed it any more.

    With regards to the refresh you can try to disable background refresh in the query options, but I haven't tried if this solves this yet.

     

    • skootz's avatar
      skootz
      Frequent Visitor
      6 years ago

      Thanks for your response :

      I have already configured the incremental refresh without these 3 tables, only, I have encountered a problem :

       

      I set up an incremental refresh on a table. I have a problem: it adds my new recordings to the table, but it does not keep the old ones. example: I have the records of my table Tab1 dated 08/31

      refresh 09/03 : addition of 09/02 records BUT REMOVAL of 08/31 records ... it does not keep in stock the 10 years that I have configured.

      Tab1 to 02/09
      08/31 : 5000 records

      09/01 : 1000 records

       

      Tab1 to 03/09
      09/01 ---> 1000 records 

      09/02 ---> 200 records

       

      Do you have a solution for me for this ?

      • ImkeF's avatar
        ImkeF
        Community Champion
        6 years ago

        Hi skootz ,

        sorry, but I don't have a solution for this.