Hi all,
I need some help
I've got an issue with PowerBI and SharePoint. I've got a list with multiple values in the list. When I try to connect to the list PowerBI throws this exception. A null value was found for the property named '[Field]', which has the expected type 'Collection(Edm.Int32)[Nullable=False]'. The expected type 'Collection(Edm.Int32)[Nullable=False]' does not allow null values.
It doesn't matter if the Field is an Multi userfield or a Multi choice, or an lookup field with multiple values.
I tried even to change the Apiversion to 14 but when I try this it show an empty table. So there isn't anything in Apiversion 14.
What to do next to fix this issue?
I tried the Odata.Feed() and the SharePoint.Tables()
