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

    Amit on 05 Jul 2020 22:01:56

    RE: SharePoint/Office 365 List Data Source

    https://app.powerbi.com does not show me sharepoint list options but it shows in powerbi designer tool

    Rui Quintino's profile image Profile Picture

    Diego on 05 Jul 2020 22:00:53

    RE: SharePoint/Office 365 List Data Source

    We need a schedule refresh data from sharepoint list in power bi site please

    Rui Quintino's profile image Profile Picture

    Amit on 05 Jul 2020 22:00:20

    RE: SharePoint/Office 365 List Data Source

    can it connect easily to on premise sharepoint 2013 lists, we have many clients with on premise

    Rui Quintino's profile image Profile Picture

    Andreas Munch, Skill AS on 05 Jul 2020 21:59:40

    RE: SharePoint/Office 365 List Data Source

    There is a simular request regarding non-english sharepoint list. http://support.powerbi.com/forums/265200-power-bi/suggestions/7318742-sharepoint-list-for-non-us-countries

    Rui Quintino's profile image Profile Picture

    Adi Mader on 05 Jul 2020 21:59:01

    RE: SharePoint/Office 365 List Data Source

    gentlemen.... yes, it is supported in PowerQuery and PowerBI Designer... but only... if the Sharepoint-Site is in english...
    Microsoft never resolved this problem for years... and I think there is an international market out there with different language settings

    Rui Quintino's profile image Profile Picture

    Miguel Llopis on 05 Jul 2020 21:58:04

    RE: SharePoint/Office 365 List Data Source

    This is supported in Power Query and the Power BI Designer. You could already connect to these sources, build your reports and upload them / schedule refresh in the Power BI service for them.

    Thanks,
    M.

    Rui Quintino's profile image Profile Picture

    o365SPO on 05 Jul 2020 21:57:38

    RE: SharePoint/Office 365 List Data Source

    '+1 on SPO List Source for Power Bi

    Rui Quintino's profile image Profile Picture

    Ned Scheetz on 05 Jul 2020 21:57:27

    RE: SharePoint/Office 365 List Data Source

    If Office 365 is really trying to capture SMB's, Power BI with List data would be an obvious add. Kind of absurd that the built in Office 365 data structure doesn't merit inclusion in the primary data analysis tool. I know lists are limited, but it's acore feature of Office 365 and most O365 users have a ton of data there.

    Rui Quintino's profile image Profile Picture

    Silviu Popa on 05 Jul 2020 21:57:23

    RE: SharePoint/Office 365 List Data Source

    this is the same as : vote there

    http://support.powerbi.com/forums/265200-power-bi/suggestions/6748539-sharepoint-office-365-list-data-source

    Rui Quintino's profile image Profile Picture

    Joseph Curet on 05 Jul 2020 21:57:15

    RE: SharePoint/Office 365 List Data Source

    SharePoint Lists are critical for my organization, we store most of our operational data in Lists. Thanks!