PowerBI Error message Collection(Edm.Int32)[Nullable=False]

[kleinbth]

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()

[Anonymous]

Does anyone have a solution for this?