Civilization VI Rise & Fall - My2K cloud save is no longer working

The OP stated in a comment that the issue was resolved the next day for no apparent reason. It might be an issue with the cloud save servers, meaning a possible solution is simply to wait.