A Chinese businessman described a “close confidante” of the Duke of York has lost an appeal over a decision to bar him from entering the UK on national security grounds.