Forum Discussion
PowerBI Desktop Get Data from SP - invalid CRLF characters
Yes, I created a brand new list - title field only. The site name is odd and unfortunately I do not have the ability to set one up with any other format. It's a generated site name in the format of WS_###### where ###### is a unique number.
Have you heard of any issues with sites with an underscore in the name?
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.
