Forum Discussion

sdeoghar's avatar
sdeoghar
Frequent Visitor
10 years ago

Unable to get data from Sharepoint online List

Hello experts,   I am trying to connect Sharepoint online list to Power BI. But its not connecting.   I am getting the below error " Unexpected Error " Specified Value has invalid CRLF character...
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
10 years ago

Hi sdeoghar,

 

As you can see from my original post, the URL of the SharePoint online list is this: https://microsoft.sharepoint.com/teams/Qiuyun01/Lists/list01, site name is Qiuyun01, then I append " _vti_bin/listdata.svc" after site name to compose the OData URL: https://microsoft.sharepoint.com/teams/Qiuyun01/_vti_bin/listdata.svc.

 

In your scenario, please also append the " _vti_bin/listdata.svc" after site name to see if the issue persists.

 

Did you try to connect to SharePoint Online list follow the steps in my orignal reply?

 

Best Regards,
Qiuyun Yu

sdeoghar's avatar
sdeoghar
Frequent Visitor
10 years ago

Hi,

 

I tried doing as you suggested, but I am still unable to cinnect. I get the same error.

 

Shivjeet