Forum Discussion

Caitlin_Knox's avatar
Caitlin_Knox
Icon for Advocate III rankAdvocate III
10 years ago

Connecting to SharePoint Online List

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-4799d267ee59')/Items

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

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

    • Caitlin_Knox's avatar
      Caitlin_Knox
      Icon for Advocate III rankAdvocate III
      10 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        Thanks. I'll try this.