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

    95573f82 05a0-468d-9ba3-d879bed59963 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

    25ec5ec3 1518-471f-a455-2ffb07cdaea0 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

    0df2347e 2805-4e08-94d1-734dcfbea696 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

    933dfac1 fda9-4b36-898d-c7271ad5a6c8 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

    fc091040 2d61-4455-9a77-ff87da0acdc6 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

    b5e35a47 3e1a-41fc-b812-411a49f78fdf 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

    41b277b4 6915-4bfd-86ae-734cc8e82ac4 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

    5db5cb92 5ede-45f3-bf65-b4340e27b720 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

    0c041582 0941-4337-81d4-51e4e640014c 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

    20ce4de0 6275-49ec-86d8-80ab4ed67724 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!