Showing results for 
Search instead for 
Did you mean: 
kleinbth Frequent Visitor
Frequent Visitor

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

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




snptune Occasional Visitor
Occasional Visitor

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

Does anyone have a solution for this?

Helpful resources

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 142 members 1,604 guests
Please welcome our newest community members: