Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
@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.