Tariffs on Canadian imports have become a political liability for U.S. President Donald Trump ahead of the midterm elections next week.