Skip to main content

    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

    3ae96ca4 5d04-4b71-8635-fb425a5a69a6 on 05 Jul 2020 22:08:53

    RE: SharePoint/Office 365 List Data Source

    '@Miguel when trying to connect to office 365 Sharepoint Online you will get the following error DataSource.Error: We couldn't parse OData response result. Error: A null value was found for the property named 'Set_x002d_aside_x0020_Type', which has the expected type 'Collection(Edm.String)[Nullable=False]'. The expected type 'Collection(Edm.String)[Nullable=False]' does not allow null values.
    Details:
    DataSourceKind=SharePoint
    DataSourcePath=https://markon365.sharepoint.com/OPS/_api/Web/Lists(guid'f1ba3235-9f27-4ce6-ace2-6f28923453026')/Items

    you must change the api version from 15 to 14 to connect

    Rui Quintino's profile image Profile Picture

    ef954aad 3a61-4e78-afa8-1eece83a995d on 05 Jul 2020 22:08:37

    RE: SharePoint/Office 365 List Data Source

    As Trump would say... this would be huuuuuuuuge. Collaborating on SharePoint Team Sites that automatically update PowerBi connections is essential!

    Rui Quintino's profile image Profile Picture

    5cdc28c0 ff0f-4f8e-b3e7-ce2e5f809247 on 05 Jul 2020 22:08:35

    RE: SharePoint/Office 365 List Data Source

    Please, make this happen Msft. You are on the right track the way products get integrated, however this a huge miss.

    Rui Quintino's profile image Profile Picture

    5d4dbaca a6fb-45bf-a6df-c29d187409a5 on 05 Jul 2020 22:08:24

    RE: SharePoint/Office 365 List Data Source

    What's the point if I cannot connect to SP lists online.

    Rui Quintino's profile image Profile Picture

    ade904fa 9e37-4167-88c1-57b79795e110 on 05 Jul 2020 22:08:16

    RE: SharePoint/Office 365 List Data Source

    I was told not to store company data in oneDrive or oneDrive for business. I had to move everything to sites. Now you tell me that I have to move it all back to oneDrive? Make up your minds.

    Rui Quintino's profile image Profile Picture

    0e0e0291 6f01-4656-a4c0-14420da2397e on 05 Jul 2020 22:08:08

    RE: SharePoint/Office 365 List Data Source

    This is available already. I'm pulling Sharepoint List Data live right now, and OData. Only in PBI Desktop though, I believe.

    Rui Quintino's profile image Profile Picture

    8e432c58 256d-46fe-a82e-918f8797335a on 05 Jul 2020 22:06:51

    RE: SharePoint/Office 365 List Data Source

    We all need that feature!!! I'm surprised its not available now!!!

    Rui Quintino's profile image Profile Picture

    85a021f9 2c18-42ac-944b-94ae63ecfd30 on 05 Jul 2020 22:06:51

    RE: SharePoint/Office 365 List Data Source

    This is a must do! Surprised it isn't already done as it should be a higher priority than onedrive

    Rui Quintino's profile image Profile Picture

    384c1d6c 15ce-4e1b-a464-4cceb7467fb8 on 05 Jul 2020 22:06:40

    RE: SharePoint/Office 365 List Data Source

    Yes... this is an important feature I would like to see.

    Rui Quintino's profile image Profile Picture

    89913b1a 2347-44c7-8760-4ff8eff45be4 on 05 Jul 2020 22:06:29

    RE: SharePoint/Office 365 List Data Source

    Please add this connectivity! I'd already sold it to my business users. They are impatient to put all their data to SP cloud and analyse it in PBI