Asda have been refused a licence to sell alcohol from a petrol station ‘100 metres’ from its main store for community safety.