Forum Discussion
PowerBI Desktop Get Data from SP - invalid CRLF characters
One other thing I noticed is that when I get the CRLF error there is no attempt being made to connect to SharePoint. I'm running Fiddler filtered for more SharePoint host. I see traffice on the authentication to the point where authentication to SP is successful but nothing after that.
When I am on the dialog - Unable to Connect - "Specified value has invalid CRLF characters. Parameter name: value" if I click Retry, I get the connecting... dialog followed by the error again. During this time no requests submitted to the SharePoint site.
I created a site called WS_123456 with a custom list called "MyList" and it worked fine in Power BI desktop connecting with Windows credentials to an on-premises SharePoint 2013 server. Running 64-bit Power BI Desktop.
The one difference between your test and my scenario is I have to connect via ADFS. I select Organizational Account as the login type and it works. The dialog states: You are currently signed in.
The error comes after that so I didn't think it was authentication related but honestly I have no idea what / where to even look to troubleshoot it further as when I run fiddler I don't see any evidence of anything happening over the network trying to connect to the SP server.