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?

We support Ukraine and condemn war. Push Russian government to act against war. Be brave, vocal and show your support to Ukraine. Follow the latest news HERE