Forum Discussion
Solved
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...
- 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
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
Hi,
Is there anywhere I can find out how to do this?
Regards,
Shylo
Hi is there somewhere I can find out how to do this please
