Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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()
Does anyone have a solution for this?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.