Error while attemting to load from Sharepoint list

[thomasreick]

Hi all,

I want load data to PBI from a SharePoint list.

Unfortunately I get the following error-message:

"DataSource.Error: We couldn't parse OData response result.  Error: A null value was found for the property named '<FieldName>', 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=https://my-confidential-sp-adress

"

While looking for a solution I have found the "ODataOmitValues.Null"-Option when dealing with OData-Feeds. Examples found are pointing to Azure so I think this works only for OData-Connectors.

Is there a way to handle this error (besides fiddling in SP-data or SP-setup) or use OData instead?

btw. OData as a connector is not working either, the sp-adress ist not recognised.

Open for any suggestions.

thx

Thomas

[v-yangliu-msft]

Hi  @thomasreick ,

Here is a link of related content, hope it will be helpful to you:

https://community.powerbi.com/t5/Power-Query/Connecting-to-a-SharePoint-List-Office-365-error/td-p/8...

https://community.powerbi.com/t5/Power-Query/Unable-to-get-data-from-Sharepoint-online-List/td-p/497...

https://social.technet.microsoft.com/Forums/en-US/b3b1dcda-d666-4e16-aae5-33870968e041/datasourceerr...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.