President Obama has rejected a Canadian company's bid to build an oil pipeline across the heart of the United States.