DataSource.Error : The server committed a protocol violation.

[steirx]

Hi,

The REST API I am trying to connect to is protected by a WAF (incapsula) that introducte wrongly formated cookies (for protection purpose, and I can't disable this protection). With a standar browser it works well but with Power BI Desktop I got this error "DataSource.Error : The server committed a protocol violation. Section=ResponseHeader Detail=CR must be followed by LF".

How can enable the parsing of unsafe header with the Web.Content query ?

Thanks.

[Anonymous]

@steirx,

I am afraid that Power BI Desktop doesn’t work with such REST API, for more details, please review the following similar threads.

https://stackoverflow.com/questions/37838007/power-bi-power-query-web-request-results-in-cr-must-be-...
https://social.technet.microsoft.com/Forums/en-US/b10b16d1-8eea-4b52-8aeb-f96ea87135fa/sectionrespon...

In your scenario, check if you can export data to other data sources, then connect to the data source in Power BI.

Regards,
Lydia

[steirx · Accepted solution]

Thanks Lydia,

I have actually used a local transparent web proxy on my Window server to remove the cookies and it works now.

Regards,

Eric

[pdacheva]

Hi @steirx,

I have the same issue. This morning when I was setting up the connection it worked properly and I was able to get the data in Power BI, but didn't save the pbix. Now I want to re-establish the connection and I get the issue: "The server committed a protocol violation. Section=ResponseHeader Detail=CR must be followed by LF". 

Could you give more details on your solution, please? 

Thanks!

[steirx]

Hi @pdacheva,

I have actually used a local web proxy (www.charlesproxy.com) to remove the wrongly formated Incapsula cookies.

Thanks

[shylobaker]

Hi is there somewhere I can find out how to do this please

[shylobaker]

Hi,

Is there anywhere I can find out how to do this?

Regards,

Shylo

[shylobaker]

Hi,

Is there anywhere I can find out how to do this?

Regards,

Shylo