Skip to main content
Microsoft Idea

    Power BI

    Completed

    SharePoint/Office 365 List Data Source

    Vote (664) Share
    Rui Quintino's profile image

    Rui Quintino on 21 Nov 2014 07:39:23

    using SharePoint lists, alternatively odata feeds

    Comments (51)
    Rui Quintino's profile image Profile Picture

    Sergey Kompaniets on 05 Jul 2020 22:12:33

    RE: SharePoint/Office 365 List Data Source

    Is SharePoint list connection live, i.e. under Power BI Pro license?

    Rui Quintino's profile image Profile Picture

    Tom Jaskula on 05 Jul 2020 22:12:16

    RE: SharePoint/Office 365 List Data Source

    I'm also seeing the ParticipantPickerID error when I try to connect to a SharePoint calendar list. How will I know if this issue is being worked on and when it will be fixed?

    Rui Quintino's profile image Profile Picture

    Christophe Humbert on 05 Jul 2020 22:11:01

    RE: SharePoint/Office 365 List Data Source

    I'll add my voice to confirm that the issue doesn't seem to be resolved. I am also seeing an endless load message and MB piling up. There's also a known issue with the Id column that is still there.

    As a workaround, I was able to query the list content via the REST OData entry point.

    Rui Quintino's profile image Profile Picture

    Tarun Bhatia on 05 Jul 2020 22:10:50

    RE: SharePoint/Office 365 List Data Source

    Not resolved yet.
    DataSource.Error: We couldn't parse OData response result. Error: An error was read from the payload. See the 'Error' property for more details.
    Details:
    DataSourceKind=SharePoint

    Rui Quintino's profile image Profile Picture

    Tarun Bhatia on 05 Jul 2020 22:10:50

    RE: SharePoint/Office 365 List Data Source

    A query with expanded lookup values and user profile values takes too much time to load. Unable to continue work as i see "Apply Query Changes" screen since past 2 hours and it has just loaded 10 MB of data :(

    Rui Quintino's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:10:45

    RE: SharePoint/Office 365 List Data Source

    The issue has not been resolved. As soon as you connect to a list with a People field that is not populated with a value, then you get the null error. I just tried this using the latest version. Only API version 14 in query seems to work.

    Rui Quintino's profile image Profile Picture

    Leif Rasmussen on 05 Jul 2020 22:09:54

    RE: SharePoint/Office 365 List Data Source

    I still get the error:
    DataSource.Error: We couldn't parse OData response result. Error: A null value was found for the property named 'ParticipantsPickerId'
    Please, please, please fix this.

    Rui Quintino's profile image Profile Picture

    Jasmine Hoegh on 05 Jul 2020 22:09:08

    RE: SharePoint/Office 365 List Data Source

    I am getting a user not authorized error even though I am the admin :(

    Rui Quintino's profile image Profile Picture

    Steven Wong on 05 Jul 2020 22:08:59

    RE: SharePoint/Office 365 List Data Source

    I agree. This is still a BUG in the software with the latest release of Power BI. REST Endpoints are not supported resulting with the error message posted by others below. The Beta worked fine. So something changed before the final release. As a work around, we have been using the legacy ListData.svc end point. This needs to be fixed before this issue/request can be closed.

    Rui Quintino's profile image Profile Picture

    David on 05 Jul 2020 22:08:54

    RE: SharePoint/Office 365 List Data Source

    I still cant get it to work, i get this error: DataSource.Error: We couldn't parse OData response result. Error: A null value was found for the property named 'SharedWithUsersId', 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://xxxxxxx.sharepoint.com/_api/Web/Lists(guid'ee102514-056c-4a0f-b8bf-b0ef1dec1ae0')/Items