Update is not allowed. But Insert is allowed.
I have tested the same entity to change the Functional location:
1) Below are the steps:
First make sure don't make changes in the exported data for Functional location, just update the Expiration date (it must be lesser than current datetime(), and greater than Effective date).
It will allow you to update the expiration date first.
2) Then, use the same exported data, make changes in the functional location id and update the Effective date (which should be equal or greater than Expiration date of previous record).
This way it works.
Regards,
Neeraj Kumar
If this helped, please mark it as "Verified" for others facing the same issue Keep in mind that it is possible to mark more than one answer as verified