Connecting to SharePoint Online List

[Caitlin_Knox]

I am following the recommended path pattern as discussed in other threads, and am able to pull up all lists available on the Team Site. However, when I select the list I wish to use, I receive the follwoing error. It began by referencing the 'program' field. I isolated the 2 items that were blank and fixed them, but now its just moved on to the next field. These are not required fields which is why some are blank. Is there an option to ignore blanks? What are my options here? Thanks

DataSource.Error: We couldn't parse OData response result.  Error: A null value was found for the property named 'AssignedTo0Id', which has the expected type 'Collection(Edm.Int32)[Nullable=False]'. The expected type 'Collection(Edm.Int32)[Nullable=False]' does not allow null values.
Details:
    DataSourceKind=SharePoint
    DataSourcePath=https://concierge1.sharepoint.com/sites/c3/resources/_api/Web/Lists(guid'512abc80-347f-49cd-a865-479...

[kelbow]

I'm encountering this as well. Is there a setting to change? I don't see an answer to this..

[Caitlin_Knox]

In my troubleshooting with Microsoft they suggested I connect using the OData feed of the SP List, which has worked fine. I use the following 'structure' and choose the OData connecter from within PBI Desktop or Excel

https://[RootSite]/sites/[Site]/[Subsite]/_vti_bin/ListData.svc/[ListName]

So, in short, this was never resolved but a suitable workaround was achieved. Hope this helps

[kelbow]

Thanks. I'll try this.