error when trying to import SharePoint list in Power BI Desktop

[Anonymous]

Hi everyone,

I want to import a Sharepoint list into power BI but it has a field with a multiple selection.

So I have the following error:

DataSource.Error : Désolé... Nous n'avons pas pu analyser le résultat de la réponse OData. Erreur : A null value was found for the property named 'Customer_x0020_Delivery_x0020_Si0', which has the expected type 'Collection(Edm.String)[Nullable=False]'. The expected type 'Collection(Edm.String)[Nullable=False]' does not allow null values.
Détails :
    DataSourceKind=SharePoint
    DataSourcePath=https://ext.stelia-aerospace.com/ns/transferts_industriels_groupe_stelia

I have seen several resolution ideas on the internet.
Like changing ApiVersion to 14 instead of 15, but that doesn't solve my problem.
And I also thought about deleting this column when importing because I don't need it, but I don't know how to do it.

Can you help me or do you have any other ideas that could help me?

Thanks in advance !

Célia

[v-yuta-msft · Accepted solution]

@Anonymous ,

"A null value was found for the property named 'Customer_x0020_Delivery_x0020_Si0', which has the expected type 'Collection(Edm.String)[Nullable=False]'. The expected type 'Collection(Edm.String)[Nullable=False]' does not allow null values."

As the error message mentioned, it seems the column 'Customer_x0020_Delivery_x0020_Si0' should not be nullable, please check if the column type can contain nullable value.

 

Community Support Team _ Jimmy Tao

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