Forum Discussion

Criptop's avatar
Criptop
Advocate I
5 years ago
Solved

Incremental Refresh Policy No Longer Valid

Hi All,

 

I can't seem to find a exisiting post with this problem, but hopefully this will be a simple fix.

 

I have an exisiting Dataset which has an incremental refresh set up that has been working with no issue up to now. A few measures have been added and I need to do a refresh from the PBIX file. I have done this before with no issues but now I get this error message:

 

 

Neither of these tables have been changed so I'm confused as to what the problem could be. 

 

Thanks in advance

Need Help
  • Criptop's avatar
    Criptop
    5 years ago

    amitchandak Thank you for your reply. However there have been no power query changes.

     

    Thankfully I appear to have got the issue resolved. For anyone else seeing this, I went into power query for the two tables and performed a preview refresh. After this, the two tables refresh as normal with no issues. Don't understand how this could have been the issue/solution but I'm just glad it's soted.

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Criptop , This should come when you delete the incremental parameter or the column used in incremental or remove the filter step in the power query. All these are because of power query changes. I doubt measure can create this error

    • Criptop's avatar
      Criptop
      Advocate I
      5 years ago

      amitchandak Thank you for your reply. However there have been no power query changes.

       

      Thankfully I appear to have got the issue resolved. For anyone else seeing this, I went into power query for the two tables and performed a preview refresh. After this, the two tables refresh as normal with no issues. Don't understand how this could have been the issue/solution but I'm just glad it's soted.