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,

 

Based on my understanding, you are trying to connect to SharePoint online list via OData feed data source type in the Power BI Desktop but get errors, right?

 

Based on my test, when we connect to SharePoint online list use OData feed, we need to append _vti_bin/listdata.svc at the end of site URL. For example, the URL of the SharePoint online list is this: https://microsoft.sharepoint.com/teams/Qiuyun01/Lists/list01, then we need to specify the OData URL like this:

 

 

 

In your scenario, please check if the URL is correct. And type the URL without copy and paste. In addition, in Power BI Desktop, there is a OOTB data source type for us to retrieve SharePoint online list, it's SharePoint Online List data source. See:

 

 

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

 

sdeoghar's avatar
sdeoghar
Frequent Visitor
10 years ago

Thank you very much for your wonderful reply.

 

I tried doing as you said and modified my URL with prefic to it as " _vti_bin/listdata.svc" but I am still getting the same error.

 

I am using sharepoint 2010, so is there anything to do with version.

 

Also to modify the URL , do we have to anything from backend or just type the original URL with adding "vti_bin/listdata.svc" at the end and hit connect.

 

Please advise.