Forum Discussion

john john's avatar
john john
Iron Contributor
Jul 11, 2019

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

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"

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

 

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

 

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?

No RepliesBe the first to reply

Resources