Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

error when trying to import SharePoint list in Power BI Desktop

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

Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    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.

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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.