Updated field showing old data

Hi,

Im using Power BI with Dynamics NAV.  In the database we have a customer with an ID number: 11701. The ID number has now been changed to 11702 and set to start tracking sales on 1.1.2018. The problem is that  now when sorting with the new customer ID number (11702) its only showing the old data of ID number 11701 and not the sales recorded after 1.1.2018.

Any ideas on this? Thanks in advance!