Error connecting sharepoint custom list with PowerBi "We couldn't parse OData response result"

Valued Contributor

We have a custom list inside our sharepoint on-premises 2013, and using the Power BI desktop app i want to connect with the sharepoint custom list. so i did the following steps:-

1) Inside power BI >> click on "Get Data" >> "SharePoint List"

splist.png

2. i entered the site url >> select the intended custom list >> but i got this error:-

navi.png

 

DataSource.Error: We couldn't parse OData response result. Error: A null value was found for the property named 'QuickOrder', which has the expected type 'Collection(Edm.String)[Nullable=False]'. The expected type 'Collection(Edm.String)[Nullable=False]' does not allow null values.
Details:
DataSourceKind=SharePoint
DataSourcePath=http://****/****/_api/Web/Lists(guid'80ca0b70-24c5-4d06-b4f4-03de6c7b733f')/Items

 

where the "QuickOrder" is a custom site column of this type

qo.png

 

so not sure why Power BI raised this error on this column specifically? is there a way to fix this error? or to exclude this column for the integration?

0 Replies
www.000webhost.com