Forum Discussion
DataSource.Error : The server committed a protocol violation.
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.
- 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
7 Replies
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-followed-by-lf-error
https://social.technet.microsoft.com/Forums/en-US/b10b16d1-8eea-4b52-8aeb-f96ea87135fa/sectionresponseheader-detailcr-must-be-followed-by-lf?forum=powerquery
In your scenario, check if you can export data to other data sources, then connect to the data source in Power BI.
Regards,
Lydia- Thanks Lydia,
I have actually used a local transparent web proxy on my Window server to remove the cookies and it works now.
Regards,
EricHi,
Is there anywhere I can find out how to do this?
Regards,
Shylo
