Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-750459%22%20slang%3D%22en-US%22%3EError%20connecting%20sharepoint%20custom%20list%20with%20PowerBi%20%22We%20couldn't%20parse%20OData%20response%20result%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-750459%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20a%20custom%20list%20inside%20our%20sharepoint%20on-premises%202013%2C%20and%20using%20the%20Power%20BI%20desktop%20app%20i%20want%20to%20connect%20with%20the%20sharepoint%20custom%20list.%20so%20i%20did%20the%20following%20steps%3A-%3C%2FP%3E%3CP%3E1)%20Inside%20power%20BI%20%26gt%3B%26gt%3B%20click%20on%20%22Get%20Data%22%20%26gt%3B%26gt%3B%20%22SharePoint%20List%22%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20472px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F123042i87AE5775C7385BED%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22splist.png%22%20title%3D%22splist.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E2.%20i%20entered%20the%20site%20url%20%26gt%3B%26gt%3B%20select%20the%20intended%20custom%20list%20%26gt%3B%26gt%3B%20but%20i%20got%20this%20error%3A-%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F123047i33181759BC471934%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22navi.png%22%20title%3D%22navi.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EDataSource.Error%3A%20We%20couldn't%20parse%20OData%20response%20result.%20Error%3A%20A%20null%20value%20was%20found%20for%20the%20property%20named%20'QuickOrder'%2C%20which%20has%20the%20expected%20type%20'Collection(Edm.String)%5BNullable%3DFalse%5D'.%20The%20expected%20type%20'Collection(Edm.String)%5BNullable%3DFalse%5D'%20does%20not%20allow%20null%20values.%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3EDetails%3A%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3EDataSourceKind%3DSharePoint%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3EDataSourcePath%3Dhttp%3A%2F%2F****%2F****%2F_api%2FWeb%2FLists(guid'80ca0b70-24c5-4d06-b4f4-03de6c7b733f')%2FItems%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhere%20the%20%22QuickOrder%22%20is%20a%20custom%20site%20column%20of%20this%20type%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20640px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F123043iE84DCDEB89C0E380%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22qo.png%22%20title%3D%22qo.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eso%20not%20sure%20why%20Power%20BI%20raised%20this%20error%20on%20this%20column%20specifically%3F%20is%20there%20a%20way%20to%20fix%20this%20error%3F%20or%20to%20exclude%20this%20column%20for%20the%20integration%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-750459%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Edevelopment%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
john john
Super 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?