Power Query Data Source Error

[plasteredric]

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?

[alansidman]

If you expect us to try an analyze this, then how about giving us the link you are trying to open.

[Brawnystaff]

Actually, looks like the URL is in the error message details section.

Not sure if you can directly interface with an online CSV file. Was able to use web browser to download CSV to hard drive and then import into Power Query. Showing 13,464 rows when fully imported.

[antoniosgrift]

Find and save the specific error: First examine the Queries & Connections pane (Select Data > Queries & Connections, select the connection, and then display the flyout). See what data access errors occurred and make note of any additional details provided. Next, open the query to see any specific errors with each query step. All errors are displayed with a yellow background for easy identification. Write down or screen capture the error message information, even if you don’t fully understand it. A colleague, administrator, or support service in your organization may be able to help you understand what happened and propose a solution.


Greetings,
Peter