Power Query Data Source Error

I've tried to set up a power query to collate some data from a website but I keep getting the error:
"DataSource.Error: The server committed a protocol violation. Section=ResponseHeader Detail=CR must be followed by LF
Details:"
When I put the address in a browser it downloads the csv straight away so not sure why excel is throwing up this error.
Any ideas how I can fix this?